Skip to main content

Qlik Sense: RowNo on a Pivot Table

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Sonja_Bauernfeind
Digital Support
Digital Support

Qlik Sense: RowNo on a Pivot Table

Last Update:

May 10, 2022 3:23:50 PM

Updated By:

Jamie_Gregory

Created date:

Oct 24, 2017 4:52:37 AM

When using RowNo to count the number of rows on a Pivot Table, it doesn't seem to work because the count starts again somewhere in the middle of the table (see below),

the count starts again somewhere in the middle of the table.png


The expected result is shown below.

expected result.png

Environment:

Cause:


The issue occurs because RowNo() returns the number of the current row within the current column segment in a table, that is the count starts again from 1 each time the value of the first dimension changes.

 

Resolution:


To get the desired result we have to use the TOTAL qualifier in the RowNo() function as shown below.

use the TOTAL qualifier in the RowNo() function.png

Labels (1)
Version history
Last update:
‎2022-05-10 03:23 PM
Updated by: