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: 
Eaun
Contributor III
Contributor III

Problem with RangeSum

I have a problem with this formula :

RangeSum(Above([Remaining Qty],0,Count(tOTAL <[Remaining Qty]>[Remaining Qty])))

Every time I put a dimension in the table the calculation fails ?

 

Before.JPG                                       After.JPG

Labels (1)
1 Solution

Accepted Solutions
Rellik
Contributor II
Contributor II

Change to :

 

RangeSum(Above([Remaining Qty],0,Count(total [Remaining Qty])))

 

and turn off sorting  😁

 

View solution in original post

1 Reply
Rellik
Contributor II
Contributor II

Change to :

 

RangeSum(Above([Remaining Qty],0,Count(total [Remaining Qty])))

 

and turn off sorting  😁