Rangesum Issue in Pivot table

Tue, 12 Aug 2014 12:46:13 GMT

Hello ,

I need help to create below report in Qlikview.

In above Report , When keep only 'KPI Cumulative' (like below report) then its work fine. but when i add KPI , KPI Cumulative shows 0 in months.

I am using below expression for KPI Cumulative :

=if($(KPI)=0,0,rangesum(above(total (KPI), 0, rowno(Total))))

Please reply and provide solution if you had face this kind of situation .

Thanks In Advance .

topic Rangesum Issue in Pivot table in QlikView