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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
patmene84
Contributor
Contributor

RangeSum Dimension Problem on Pivot Table

Hello everybody,

I have a problem on Qlik Sense. In a Pivot Table I want to do a cumulative sum for only one dimension and a normal sum for the others.

In the measure expression I used the following function:  

=if(dimensionality()=3

,rangesum(above(Total sum([Valore Co. Ge.]),0,RowNo(Total)))

,sum([Valore Co. Ge.]))

It seems to be good for a cumulative sum for dimension 3 and a normal sum for other dimensions untill when I expand my pivot table and  I have a zero line values like the screen:

Screen1.PNGScreen2.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

How could I fix my formula to have the correct cumulative sum when I expand my Pivot Table instead of the zero values?

 

Thanks in advance

 

Patrick

0 Replies