Discussion Board for collaboration related to QlikView App Development.
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 ?
Add an expression that says:
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
rowno() as Row
and take this row into pivot dimension
Use resident table in this case. Can you share any sample.
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.
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)