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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
louise119
Creator III
Creator III

Rangesum function and below

I want to use the RangeSum function and above on a table containing dates.

I want the dates displayed in the table to be displayed in descending order.
Can I change the order of count? I tried to use "below",but it doesn't work.

I wanna count from the oldest date to newest date.( from bottom to top)
I don't wanna use script. 

formula:
= RangeSum(above(count(if([id]='2,[id])),0,RowNo(total)))


test.png


Thank you.

1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

Could you paste your below example? It should work.

There is a opened and never closed ' in your expression

RangeSum(above(count(if([id]='2,[id])),0,RowNo(total)))

 

View solution in original post

1 Reply
Clever_Anjos
Employee
Employee

Could you paste your below example? It should work.

There is a opened and never closed ' in your expression

RangeSum(above(count(if([id]='2,[id])),0,RowNo(total)))