Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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