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: 
stevegimbrollmt
Creator II
Creator 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
MayilVahanan

Hi

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

RowNo(Total)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

10 Replies
bbi_mba_76
Partner - Specialist
Partner - Specialist

Hi,

maybe with

=rowNo(Total)

MK_QSL
MVP
MVP

ROWNO()

Anonymous
Not applicable

Steve

Try

     =rowno(total)

Best Regards,     Bill

MayilVahanan

Hi

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

RowNo(Total)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
stevegimbrollmt
Creator II
Creator II
Author

Guys, you are all wicked,

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

rafael_encinas
Contributor II
Contributor II

Thanks !

Senior Qlik Architect
Cobra, Stallone, "You're a problem and I'm the solution"
Alfovic
Contributor II
Contributor II

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!

skychris
Contributor II
Contributor II

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
Contributor II
Contributor II

Great!!!!!!!! Thanks