Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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 (2)
1 Solution

Accepted Solutions
Highlighted

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

View solution in original post

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

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

Highlighted

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

View solution in original post

Highlighted
Creator II
Creator II

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 👍