Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
valnod_90
Contributor III
Contributor III

Progressive number of rows

Hello everyone!

I was wondering if there is an easy way to create a dimension that includes the progressive number of each row in a straight table.

For example, how Excel works on every sheet.

Thank you!

excelexample.png

1 Solution

Accepted Solutions
marcus_sommer

Try with a change of rowno() to rowno(TOTAL).

- Marcus

View solution in original post

4 Replies
marcus_sommer

You could use rowno() as expression within the straight-table and drag them to the first column of the object.

- Marcus

valnod_90
Contributor III
Contributor III
Author

Hello Marcus,

I tried but this is what happened

rowno.png

marcus_sommer

Try with a change of rowno() to rowno(TOTAL).

- Marcus

valnod_90
Contributor III
Contributor III
Author

It works now!

Thank you!