topic Re: Serial number in Pivot table in QlikView

Serial number in Pivot table

yoganantha321 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a table of data in pivot table. like below

I need a additional column of S.No(Serial Number) in front of the table.

I saw a solution of addition of column in script but it is waste of use. Because it shows the value stored in the table not the dynamic values while apply filters.

So any body help me.

regards,

Yoganantha Prakash G P

Re: Serial number in Pivot table

tresB — Fri, 28 Apr 2017 10:57:33 GMT

May be using a calculated dimension like:

=Aggr(RowNo(total), ...,Dim2,Dim1)

Re: Serial number in Pivot table

Fri, 28 Apr 2017 11:13:17 GMT

Hi Yoganantha Prakash G P,

Are you able to provide some sample data/qvw for testing?

Warm regards,

Nish

Re: Serial number in Pivot table

tamilarasu — Fri, 28 Apr 2017 11:28:52 GMT

Hi Yoganantha,

Use the below as expression and move the column to front of the table.

=RowNo(TOTAL)

Re: Serial number in Pivot table

yoganantha321 — Fri, 28 Apr 2017 11:33:04 GMT

Hi nagaraj,

I can move till the previous expression but I cannot move beyond which has more dimensions in front of it

Re: Serial number in Pivot table

tamilarasu — Fri, 28 Apr 2017 12:09:04 GMT

Hi Yoganantha,

Looks like you are using pivot table. If that is the case, you can use Tresesco's solution.