Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Not applicable

Re: Show dynamic RowNo in straight table

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
Highlighted
Not applicable

Re: Show dynamic RowNo in straight table

Use this expression..

RowNo(TOTAL)    

Karthik

Highlighted
Not applicable

Re: Show dynamic RowNo in straight table

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

Highlighted
Not applicable

Re: Show dynamic RowNo in straight table

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

Highlighted
Not applicable

Re: Show dynamic RowNo in straight table

Thanks a lot! Smart solution.

/ Matt

Highlighted
Partner
Partner

Re: Show dynamic RowNo in straight table

karthiks, Not found for 2 dimensions

I think better use RowNo(TOTAL)

Highlighted
Not applicable

Re: Show dynamic RowNo in straight table

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

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

Karthik

Highlighted
Contributor
Contributor

Re: Show dynamic RowNo in straight table

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