Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hello,
Does this meet your needs?
RangeSum(Above((1), 0, NoOfRows()))
Try this
Aggr(Rank(Sum(Sales), 4), [YourDimension])