Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

juan_escobar
Contributor

numbers in pivot table

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

1 Solution

Accepted Solutions
jvitantonio
Valued Contributor III

numbers in pivot table

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

3 Replies

numbers in pivot table

HI,

     Use rowno() in expression

Regards,

Kaushik Solanki

MVP
MVP

numbers in pivot table

Try this

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

jvitantonio
Valued Contributor III

numbers in pivot table

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

Community Browser