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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
samyurchuk
Contributor II
Contributor II

Qlik Sense Table with RangeSum and Two Dimensions

I have a table with the following columns:  NET_BILLING_AMT, Cumulative Sales and Material ID.  Using the formula rangesum(above(sum(NET_BILLING_AMT),0,rowno()))   for Cumulative Sales, everything works fine. 

I would like to add another Dimension  to the table called MATERIAL_NAME.  I've  tried aggr(rangesum(above(sum(NET_BILLING_AMT),0,rowno())), MATERIAL_ID, MATERIAL_NAME) for Cumulative Sales after adding the MATERIAL_NAME to the table but the column is not accumulating.

Labels (1)
1 Solution

Accepted Solutions
marcus_sommer

Just try it without the aggr() but with TOTAL in rowno() and/or above() like:

rangesum(above(TOTAL sum(NET_BILLING_AMT),0,rowno(TOTAL)))

- Marcus

View solution in original post

2 Replies
marcus_sommer

Just try it without the aggr() but with TOTAL in rowno() and/or above() like:

rangesum(above(TOTAL sum(NET_BILLING_AMT),0,rowno(TOTAL)))

- Marcus

samyurchuk
Contributor II
Contributor II
Author

Perfect!  That worked. Thanks for the help😊, Marcus.