Numeration of rows

[sculptorlv]

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?

[sunny_talwar]

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:

The sortable Aggr function is finally here!

[Kushal_Chawda · Accepted solution]

Try Expression

=RowNo(Total)

[swuehl]

Sunny, I think this might get messed up depending on the LOAD order of UniqueIdentifier vs. Pivot table sort order.

[sunny_talwar]

You are right, I just updated my response above to point to the use of structured parameter

[sculptorlv]

This work perfect!

Thank you!

[swuehl]

How have you managed to get this expression column in the first row  column in your pivot table chart?

[sunny_talwar]

May be the OP meant the first expression column

[sculptorlv]

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.

[sunny_talwar]

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?