Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team
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 expected result is shown below.
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.
Qlik Cloud
Qlik Cloud
Qlik Sense Enterprise on Windows
Qlik Sense Enterprise on Windows
Qlik Sense Desktop
Qlik Sense Desktop
Qlik Sense Business
Qlik Sense Business
