RowNO

Joaovrs — Tue, 18 Mar 2025 13:45:42 GMT

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?

Re: RowNO

Clement15 — Tue, 18 Mar 2025 16:33:35 GMT

Hello,

Does this meet your needs?

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

Re: RowNO

Chanty4u — Wed, 19 Mar 2025 19:43:57 GMT

Try this

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

topic Re: RowNO in App Development

RowNO

Re: RowNO

Re: RowNO