Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I have one quastion, hope for your help.
I have a Pivot Table Chart in my Qlik View area ... like:
Name Code Country
Mike 234 Latvia
George 1414 Estoni
Lena 3423 USA
etc...
I need to add a column with numeration of rows in order to get such table:
Nr. Name Code Country
1 Mike 234 Latvia
2 George 1414 Estoni
3 Lena 3423 USA
etc...
How can I add such first column, where numeartion of rows will be always available?
May be something like this:
Aggr(RowNo(), UniqueIdentifier)
Note, if you are using QV12, you might be able to set the order using the new structured parameter as discussed here:
Try Expression
=RowNo(Total)
Sunny, I think this might get messed up depending on the LOAD order of UniqueIdentifier vs. Pivot table sort order.
You are right, I just updated my response above to point to the use of structured parameter
This work perfect!
Thank you!
How have you managed to get this expression column in the first row column in your pivot table chart?
May be the OP meant the first expression column
Yes, I put this into expression and moved it to the start.
My goal is to create Excel table with given parametrs in order to make export to an old programm.
I have several more diffculties with it ..thus may be this solution will not work for 100% .. but it is excatly that I wanted.
You mentioned Pivot table in your initial post. How did you manage to move the expression it before the dimensions? or are you using straight table?