Number of row in a pivot table

[#1]

Hi all.

Somebody can help me?

Is there a way or a function to have a column with a progressive number of row in a pivot table ?

Thank All

[m_woolf]

Add an expression that says:

     =rowno(Total)

[#3]

Thank mwllof,

but if i want use the "=rowno(Total)" in a dimension and not in a expression, how can i do it?

[SunilChauhan]

in script load like this

Load

a,

b,

c,

rowno() as Row

from table;

and take this row into pivot dimension

[its_anandrjs]

Hi mwllof,

Use resident table in this case. Can you share any sample.

Regards,

Anand

[#6]

Ok,

the first solution (=rowno(Total) ) is ok.

But i would have a number that is generated automatically in the first column (a dimension) of a pivot table, therefore it changes according to the selctions made.

   Thank

[brunobertels]

hi 

in late but have a look here https://community.qlik.com/t5/forums/replypage/board-id/french-group/message-id/15950 

Aggr(rowno() &' - ' &Yourdimension, Yourdimension)