Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

sculptorlv
Contributor III

Numeration of rows

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?

1 Solution

Accepted Solutions

Re: Numeration of rows

Try Expression

=RowNo(Total)

View solution in original post

9 Replies

Re: Numeration of rows

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!

Re: Numeration of rows

Try Expression

=RowNo(Total)

View solution in original post

MVP
MVP

Re: Numeration of rows

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

Re: Numeration of rows

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

sculptorlv
Contributor III

Re: Numeration of rows

This work perfect!

Thank you!

MVP
MVP

Re: Numeration of rows

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

Re: Numeration of rows

May be the OP meant the first expression column

sculptorlv
Contributor III

Re: Numeration of rows

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.

Re: Numeration of rows

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?