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: 
Joaovrs
Contributor
Contributor

RowNO

Hello everyone, I would like your help. I have a table in Qlik Sense where I need to create an ordering column (1, 2, 3, 4, 5) that is flexible, so that regardless of which dimension or measure is chosen for sorting, if I sort by sales, the line with the most sales is 1, if it is by profit, the line with the highest profit is 1. RowNo only works for dimensions, but when choosing measures for sorting nothing changes in the table, so could someone help me?

Labels (1)
2 Replies
Clement15
Partner - Specialist
Partner - Specialist

Hello,

Does this meet your needs?

RangeSum(Above((1), 0, NoOfRows()))

Chanty4u
MVP
MVP

Try this 

Aggr(Rank(Sum(Sales), 4), [YourDimension])