Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Total on Pivot Table

Hi ,

I calculated percentage in a pivot table with the expression

Count (Dc)/Count( All <Lib_TC , Flag_APC> Dc)

I have 3 dimensions : Lib_TC, Flag_APC & Nb_SV.

I'd like to add as a new column a total by row (= 100%)

This my table result

Lib_TCFlag_APCNb_SV01234Plus de 5
1: < 500 hab.053,1%26,5%11,0%4,4%2,0%3,0%
1: < 500 hab.112,4%24,6%22,2%16,2%9,4%15,2%
2: 500 à 1000 hab.08,3%17,4%18,3%14,1%9,9%31,9%
2: 500 à 1000 hab.12,4%9,7%16,2%17,7%14,9%39,1%
Total30,1%18,3%10,8%6,7%4,6%29,4%

Thanks for your help

Jean-Jacques

Labels (1)
2 Replies
Not applicable
Author

What about expression which would be summing all expresion?? It should give you back 100%

Not applicable
Author

I just want to add a new column with (for this example) a total of 100% for each. More generally, how can I put a total in pivot-table. I just success only with one dimension.

Thanks for your help

JJ