topic Re: Number rows by dimension in QlikView

Number rows by dimension

Pedro_Rodriguez — Thu, 19 Jul 2018 08:29:32 GMT

Hi everyone,

I have a table with a Dimension and a value:

What I want to get is a new RowNo() Column numbering the rows by Dimension value so it gets like this:

I need to do it by scripting to generate a QVD.

Thanks a lot in advance

tresB — Thu, 19 Jul 2018 08:37:03 GMT

Try like:

Load

AutoNumber(RowNo(), Dimens) as Row

Pedro_Rodriguez — Thu, 19 Jul 2018 08:43:57 GMT

Thanks a lot, works perfectly!!!