Percentage calculation

[#1]

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.

[alexandros17]

There is a checkbox "relative", try to check ...

[MK_QSL · Accepted solution]

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)

[#4]

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.