topic Re: show row number in straight table in QlikView

show row number in straight table

stevegimbrollmt — Tue, 19 Nov 2013 10:03:16 GMT

Hi all,

I thought it was more straight forward or I am not really doing it right, I want to create a dummy column and display the row number at design level.

Any idea? wouldn't the rowno() be good enough?

Thanks

Re: show row number in straight table

bbi_mba_76 — Tue, 19 Nov 2013 16:36:42 GMT

Hi,

maybe with

=rowNo(Total)

Re: show row number in straight table

MK_QSL — Tue, 19 Nov 2013 17:18:14 GMT

ROWNO()

Re: show row number in straight table

Anonymous — Tue, 19 Nov 2013 17:28:27 GMT

Steve

Try

=rowno(total)

Best Regards, Bill

Re: show row number in straight table

MayilVahanan — Tue, 19 Nov 2013 17:33:59 GMT

Its depends on your requirement, if you like to show each and every row no, then use Rowno() , else

RowNo(Total)

Re: show row number in straight table

stevegimbrollmt — Wed, 20 Nov 2013 09:42:05 GMT

Guys, you are all wicked,

thanks for your help.. I have to say that =rowno(total) in an expression did the job.

Re: show row number in straight table

rafaelencinas — Sun, 07 Apr 2019 20:27:42 GMT

Thanks !

Re: show row number in straight table

Alfovic — Fri, 03 May 2019 12:56:25 GMT

Hi i have one question regarding this, by using RowNo(TOTAL) it turn off sorting by measures, is any other way where I can get the row number and still use sorting by measures in the tables?

Thanks!

Re: show row number in straight table

skychris — Mon, 24 Jun 2019 03:22:24 GMT

Hi Guy, when export out to excel, the RowNo(Total) is always at the last row which suppose to be the 1st row

any resolution ?

Re: show row number in straight table

maykerreyes — Wed, 21 Aug 2019 23:08:05 GMT

Great!!!!!!!! Thanks

Re: show row number in straight table

VivenReddy — Fri, 06 May 2022 23:16:57 GMT

did you find a solution to this issue? Is there an alternate method of numbering the rows so that sorting works?