Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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!