topic Pivot table: how to calculate % ref other group in QlikView

Pivot table: how to calculate % ref other group

mee-qlik — Tue, 18 Jul 2017 13:53:56 GMT

In a pivot table whit 4 dimension and 1 expression ( a rangesum calc , thanks to Sunny Talvar for the help) now I have to calculate for the dimension "Conto" with ind_C_R = "C" the % vs total of group with ind_C_R ='R'

In the example , for the "CONTO" = 244 , the correct values would be abs(-111637.52 / 3431014.57) = 3.25377 ... % and so on with "CONTO" 201 ... 417

Thanks!!

Re: Pivot table: how to calculate % ref other group

sunny_talwar — Tue, 18 Jul 2017 14:04:46 GMT

May be this

Sum({<IND_C_R={'C'}>} VALORE)/Sum(TOTAL {<IND_C_R={'R'}>} VALORE)

Re: Pivot table: how to calculate % ref other group

mee-qlik — Tue, 18 Jul 2017 17:05:28 GMT

Yes, correct.

My problem is al little bit complicated, I will post another example.

Thanks again!