Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rangesum Issue in Pivot table

Hello ,

I need help to create below report in Qlikview.

Year2014
MonthJANFEBMARCH
KPI
KPI Cumulative

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.

Year2014
MonthJANFEBMARCH
KPI Cumulative

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 .

0 Replies