topic Re: Show dynamic RowNo in straight table in QlikView

Show dynamic RowNo in straight table

Wed, 12 Jun 2013 08:16:11 GMT

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.

Best regards

/ Matt

Re: Show dynamic RowNo in straight table

Wed, 12 Jun 2013 08:26:43 GMT

Use this expression..

RowNo(TOTAL)

Karthik

Re: Show dynamic RowNo in straight table

Wed, 12 Jun 2013 08:31:05 GMT

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

Re: Show dynamic RowNo in straight table

Wed, 12 Jun 2013 09:02:25 GMT

Hi.

Find attachment.. It will solve ur problem.

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

Re: Show dynamic RowNo in straight table

Wed, 12 Jun 2013 09:06:53 GMT

Thanks a lot! Smart solution.

/ Matt

Re: Show dynamic RowNo in straight table

eddysanchez — Tue, 30 Jul 2013 15:02:10 GMT

karthiks, Not found for 2 dimensions

I think better use RowNo(TOTAL)

Re: Show dynamic RowNo in straight table

Tue, 30 Jul 2013 16:18:51 GMT

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

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

Karthik

Re: Show dynamic RowNo in straight table

MaxC — Thu, 31 Oct 2019 22:45:43 GMT

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