topic Issue with RowNo() in QlikView

Issue with RowNo()

Black_Hole — Sat, 16 Nov 2024 00:08:43 GMT

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:

> Properties view:

Please could you help me to resolve this issue.

Thank you in advance for your help.

Re: Issue with RowNo()

marcus_sommer — Thu, 13 Aug 2020 14:30:28 GMT

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

Re: Issue with RowNo()

sunny_talwar — Thu, 13 Aug 2020 16:51:39 GMT

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

Re: Issue with RowNo()

Black_Hole — Tue, 18 Aug 2020 11:50:53 GMT

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 👍