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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
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])