topic Re: Adding a serial number in pivot table in QlikView

Adding a serial number in pivot table

fj11 — Fri, 31 Jul 2020 07:49:11 GMT

I want to add serial number as first column(dimension) in my pivot table. I tired using RowNo() but it doesnt give me expected results because i sort the table on a different measure and adding rowno() , removes the sorting done with a different measure.

Any suggestions on how do i keep the sorting in place as well as add serial no as a first col. in my pivot table?

Re: Adding a serial number in pivot table

sergio0592 — Fri, 31 Jul 2020 09:05:39 GMT

And in Properties/Sort tab, if use sort with expression ?

Re: Adding a serial number in pivot table

fj11 — Fri, 31 Jul 2020 09:27:37 GMT

Already tried sorting ,with the sorting expression on on 'rowno() dimension'. but then the serial nos are displayed as random numbers like 10, 5, 3,1,7 etc instead on 1,2,3,4,5

I have attached screenshot for your reference for the numbers displayed as serial no. when i add sorting expression on rowNo() dimension

Re: Adding a serial number in pivot table

Brett_Bleess — Thu, 13 Aug 2020 14:38:14 GMT

Stupid question, would RecNo() work in this case instead of RowNo()?

Regards,
Brett

Re: Adding a serial number in pivot table

firoz24 — Thu, 08 Feb 2024 03:56:47 GMT

I have same issue is it possible ?

Did you find the solution?

Re: Adding a serial number in pivot table

marcus_sommer — Thu, 08 Feb 2024 08:53:55 GMT

AFAIK the rowno() dependency to the sorting isn't to change. But you could try to replace it with a rank() approach, like:

aggr(rank(YourSortExpression), Dim1, Dim2)