topic Percentage calculation in QlikView

Percentage calculation

Tue, 01 Apr 2014 15:52:43 GMT

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.

Re: Percentage calculation

alexandros17 — Tue, 01 Apr 2014 15:55:39 GMT

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

Re: Percentage calculation

MK_QSL — Tue, 01 Apr 2014 15:56:06 GMT

SUM({<School = {'A'}>}Transcripts) /SUM(TOTAL Transcripts)

SUM({<School = {'A'}>}Transcripts) /SUM({1}Transcripts)

SUM(Transcripts) /SUM(TOTAL Transcripts)

SUM(Transcripts) /SUM({1}Transcripts)

Re: Percentage calculation

Tue, 01 Apr 2014 16:42:48 GMT

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.