Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

stevegimbrollmt
Contributor II

show row number in straight table

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

1 Solution

Accepted Solutions

Re: show row number in straight table

Hi

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

RowNo(Total)

9 Replies
bbi_mba_76
Valued Contributor

Re: show row number in straight table

Hi,

maybe with

=rowNo(Total)

MVP
MVP

Re: show row number in straight table

ROWNO()

Re: show row number in straight table

Steve

Try

     =rowno(total)

Best Regards,     Bill

Re: show row number in straight table

Hi

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

RowNo(Total)

stevegimbrollmt
Contributor II

Re: show row number in straight table

Guys, you are all wicked,

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

rafael_encinas
New Contributor

Re: show row number in straight table

Thanks !

Highlighted
Alfovic
New Contributor

Re: show row number in straight table

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!

seowkian63
New Contributor

Re: show row number in straight table

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 ?

maykerreyes
New Contributor II

Re: show row number in straight table

Great!!!!!!!! Thanks