Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
MVP & Luminary
MVP & Luminary

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
MVP & Luminary
MVP & Luminary

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

Contributor II
Contributor II

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