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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Black_Hole
Creator II
Creator II

Issue with RowNo()

Hello all,

In a graphic table, I added a column with  RowNo() as an expression.

However, the row numbers displayed on my table are not correct. I don't understand what happened!

> Table view:

TableDisplayed.PNG

> Properties view:

ExpressionView.PNG

Please could you help me to resolve this issue.

Thank you in advance for your help.

Labels (3)
1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP

Do you need may be RowNo(TOTAL) to get a continuous row number count

View solution in original post

3 Replies
marcus_sommer
MVP
MVP

I assume the dimensions within your table aren't properly associated to eachother and therefore some rows will be duplicated. Before playing further with this table I suggest to create a tablebox with all relevant fields and to ensure that a definite unique key is included (if none exists within the datamodel you could there with recno() and/or rowno() create some) and then to check if all data and the relations of them are like expected.

- Marcus

sunny_talwar
MVP
MVP

Do you need may be RowNo(TOTAL) to get a continuous row number count

Black_Hole
Creator II
Creator II
Author

Hello @marcus_sommer , @sunny_talwar ,

Thank you both for your help.

@sunny_talwar : I tried and that's work perfectly! Thank you very much for this solution 👍