Discussion Board for collaboration on QlikView Scripting.
Hi Dear friends,
Here in the pivot table how to create subtotal and grand total .
Thanks in advance,
Try the below expression in your performance column,
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 %]))
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.