topic Pivot Table sub total and grand total in QlikView

Pivot Table sub total and grand total

Anonymous — Wed, 05 Aug 2015 09:19:56 GMT

Hi Dear friends,

Here in the pivot table how to create subtotal and grand total .

Thanks in advance,

Bunny

settu_periasamy — Thu, 06 Aug 2015 15:16:22 GMT

Hi,

Try the below expression in your performance column,

if(Dimensionality()=0,

Avg(Aggr(Avg(([Passed / Collected 2015]/[Total/ Analyzed])/[Target %])*(Sum(CLP)/Sum(TOTAL CLP)),Query3.Water_System))*2,

Avg(([Passed / Collected 2015]/[Total/ Analyzed])/[Target %]))

Anonymous — Sat, 08 Aug 2015 10:44:02 GMT

Hi yeah its working for the particular qv file but i m having a large huge data there this logic not working .. i m trying to solve it.