Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Add an expression that says:
=rowno(Total)
Thank mwllof,
but if i want use the "=rowno(Total)" in a dimension and not in a expression, how can i do it?
in script load like this
Load
a,
b,
c,
rowno() as Row
from table;
and take this row into pivot dimension
Hi mwllof,
Use resident table in this case. Can you share any sample.
Regards,
Anand
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
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)