Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show dynamic RowNo in straight table

Hi,

I'm trying to achieve a dynamic ranking based on active sort order in a straight table. In the example below I have sorted on Product Name, Sales and Margin. Actually the the only thing I need is a static row number as a Rank field. I have tried with RowNo() but without success.

Thanks in advance for helping me out.

rank.PNG

Best regards

/ Matt

1 Solution

Accepted Solutions
Not applicable
Author

Hi.

Find attachment.. It will solve ur problem.

But it very old method. May be some one else give good solution..

View solution in original post

7 Replies
Not applicable
Author

Use this expression..

RowNo(TOTAL)    

Karthik

Not applicable
Author

For me that doesn't work. RowNo(TOTAL) only seem to sort on Product name regardless my chosen sort order. (double click on headername).

Not applicable
Author

Hi.

Find attachment.. It will solve ur problem.

But it very old method. May be some one else give good solution..

Not applicable
Author

Thanks a lot! Smart solution.

/ Matt

eddysanchez
Partner - Creator
Partner - Creator

karthiks, Not found for 2 dimensions

I think better use RowNo(TOTAL)

Not applicable
Author

But for his case.. he need to use sort option..

If we use RowNo() then sort option doesn't work ..

Karthik

MaxC
Contributor
Contributor

Thanks, this does work....make sure you select Full Accumulation on the Rank expression