topic numbers in pivot table in QlikView

numbers in pivot table

Anonymous — Tue, 06 Mar 2012 13:03:35 GMT

Hello,

I have this pivot table and I have a dimension called "Codigo Solicitante", now I want to coutn ALL this rows, but in a new colum assign a number:

Codigo Solicitante Number

174903284 1

121497643 2

. .

And so on... and at the end the TOTAL row.

How can I do that

kaushiknsolanki — Tue, 06 Mar 2012 13:06:19 GMT

HI,

Use rowno() in expression

Regards,

Kaushik Solanki

swuehl — Tue, 06 Mar 2012 13:08:31 GMT

Try this

if(dimensionality()=0,count(distinct [Codigo Solicitante]), rowno() )

jvitantonio — Tue, 06 Mar 2012 13:09:22 GMT

Juan, go to the pivot table, on the expression put "=RowNo()"