Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a column with total number of transcripts received per school and I need to get a percentage of this column. Is it possible to get this number directly in Qlikview?
For example:
Total Transcripts from School A is 782 and Total transcripts is 32198.
To get the percentage : Total Transcripts from School A / Total transcripts.
782/32198 = 0.024%
I tried this but it does not work. Does anyone have a solution?
Thank you.
SUM({<School = {'A'}>}Transcripts) /SUM(TOTAL Transcripts)
or
SUM({<School = {'A'}>}Transcripts) /SUM({1}Transcripts)
Or
SUM(Transcripts) /SUM(TOTAL Transcripts)
or
SUM(Transcripts) /SUM({1}Transcripts)
There is a checkbox "relative", try to check ...
SUM({<School = {'A'}>}Transcripts) /SUM(TOTAL Transcripts)
or
SUM({<School = {'A'}>}Transcripts) /SUM({1}Transcripts)
Or
SUM(Transcripts) /SUM(TOTAL Transcripts)
or
SUM(Transcripts) /SUM({1}Transcripts)
Thank you, Alessandro, that tip was helpful.
Manish, the calculation SUM(Transcripts) /SUM(TOTAL Transcripts) worked for my purposes.
Thank you both for your help.