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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
jolivares
Specialist
Specialist

Populate Acumulation in diferent dimension

See the example attach

1 Reply
stephencredmond
Partner - Specialist II
Partner - Specialist II

Hi,

You have a couple of things wrong with your expression:

   RangeSum(Above(total Sum(Value),0,RowNo(TOTAL)))

Now, the only problem is that it will not aggregate if the dimension is collapsed.  This is because if it is collapsed, the Above(Total Sum(Value)) doesn't make any sense - there is no row above.

Regards,


Stephen