Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. 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 👍