Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamic Row No in Table

Hi All,

Thanks a lot for your help and support. I have a query . I wanted to insert row no in table below like 1,2,3 ,etc  I tried  rowno() function but it is not working

Capture.PNG.png

Can anyone please help me on this?

Thanks a lot for your help

1 Solution

Accepted Solutions
nizamsha
Specialist II
Specialist II

uncheck  in expression tab->Total Mode-> Check no total

or see the file i have attached

View solution in original post

5 Replies
nizamsha
Specialist II
Specialist II

Rowno(Total) in ur expression

and check no total then bring the  rowno(total) as First column by dragging

nizamsha
Specialist II
Specialist II

PFA

Not applicable
Author

I added RowNo(TOTAL) to expression and moved the column to first. Its working only issue is that its showing 0 in total row.

query response 1.png

can we show it blank or total no of rows in table ?

Many thanks for your help

nizamsha
Specialist II
Specialist II

uncheck  in expression tab->Total Mode-> Check no total

or see the file i have attached

Not applicable
Author

Thanks its working fine