Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Number of row in a pivot table

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

6 Replies
Highlighted
Master II
Master II

Add an expression that says:

     =rowno(Total)

Highlighted
Not applicable

Thank mwllof,

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

Highlighted
Champion
Champion

in script load like this

Load

a,

b,

c,

rowno() as Row

from table;

and take this row into pivot dimension

Highlighted

Hi mwllof,

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

Regards,

Anand

Highlighted
Not applicable

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

Highlighted
Specialist II
Specialist II

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)