Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
m_woolf
Master II
Master II

Add an expression that says:

     =rowno(Total)

Not applicable
Author

Thank mwllof,

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

SunilChauhan
Champion
Champion

in script load like this

Load

a,

b,

c,

rowno() as Row

from table;

and take this row into pivot dimension

Sunil Chauhan
its_anandrjs

Hi mwllof,

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

Regards,

Anand

Not applicable
Author

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
Master
Master

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)