topic Total on Pivot Table in QlikView

Total on Pivot Table

Mon, 30 Nov 2009 18:27:13 GMT

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_TC	Flag_APC	Nb_SV	0	1	2	3	4	Plus de 5
1: < 500 hab.	0		53,1%	26,5%	11,0%	4,4%	2,0%	3,0%
1: < 500 hab.	1		12,4%	24,6%	22,2%	16,2%	9,4%	15,2%
2: 500 à 1000 hab.	0		8,3%	17,4%	18,3%	14,1%	9,9%	31,9%
2: 500 à 1000 hab.	1		2,4%	9,7%	16,2%	17,7%	14,9%	39,1%
Total			30,1%	18,3%	10,8%	6,7%	4,6%	29,4%

Thanks for your help

Jean-Jacques

Total on Pivot Table

Mon, 30 Nov 2009 18:34:11 GMT

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

Re. :Re: Total on Pivot Table

Tue, 01 Dec 2009 00:10:53 GMT

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