https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-RowNo-on-a-Pivot-Table/ta-p/1710219 <P>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),<BR /><BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="the count starts again somewhere in the middle of the table.png" style="width: 555px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/52055i424FE890DB5CEE55/image-size/large?v=v2&amp;px=999" role="button" title="the count starts again somewhere in the middle of the table.png" alt="the count starts again somewhere in the middle of the table.png" /></span><BR /><BR /><BR />The expected result is shown below.<BR /><BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="expected result.png" style="width: 549px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/52056iB74A6A22B91E0244/image-size/large?v=v2&amp;px=999" role="button" title="expected result.png" alt="expected result.png" /></span><BR /><BR /><STRONG>Environment:</STRONG></P> <UL> <LI><LI-PRODUCT title="Qlik Sense Enterprise SaaS" id="qlikSenseEnterpriseSaaS"></LI-PRODUCT>&nbsp;</LI> <LI><LI-PRODUCT title="Qlik Sense Enterprise on Windows" id="qlikSenseEnterpriseWindows"></LI-PRODUCT>&nbsp;, any</LI> <LI><LI-PRODUCT title="Qlik Sense Desktop" id="qlikSenseDesktop"></LI-PRODUCT>&nbsp;</LI> <LI><LI-PRODUCT title="Qlik Sense Business" id="qlikSenseBusiness"></LI-PRODUCT>&nbsp;<BR />&nbsp;</LI> </UL> <H4 class="qlik-migrated-tkb-headings">Cause:</H4> <P><BR />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.</P> <P>&nbsp;</P> <H4 class="qlik-migrated-tkb-headings">Resolution:</H4> <P><BR />To get the desired result we have to use the TOTAL qualifier in the RowNo() function as shown below.<BR /><BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="use the TOTAL qualifier in the RowNo() function.png" style="width: 550px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/52057i3A2B747669CF7DE2/image-size/large?v=v2&amp;px=999" role="button" title="use the TOTAL qualifier in the RowNo() function.png" alt="use the TOTAL qualifier in the RowNo() function.png" /></span></P> Tue, 10 May 2022 19:23:50 GMT Sonja_Bauernfeind 2022-05-10T19:23:50Z https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-RowNo-on-a-Pivot-Table/ta-p/1710219 <P>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),<BR /><BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="the count starts again somewhere in the middle of the table.png" style="width: 555px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/52055i424FE890DB5CEE55/image-size/large?v=v2&amp;px=999" role="button" title="the count starts again somewhere in the middle of the table.png" alt="the count starts again somewhere in the middle of the table.png" /></span><BR /><BR /><BR />The expected result is shown below.<BR /><BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="expected result.png" style="width: 549px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/52056iB74A6A22B91E0244/image-size/large?v=v2&amp;px=999" role="button" title="expected result.png" alt="expected result.png" /></span><BR /><BR /><STRONG>Environment:</STRONG></P> <UL> <LI><LI-PRODUCT title="Qlik Sense Enterprise SaaS" id="qlikSenseEnterpriseSaaS"></LI-PRODUCT>&nbsp;</LI> <LI><LI-PRODUCT title="Qlik Sense Enterprise on Windows" id="qlikSenseEnterpriseWindows"></LI-PRODUCT>&nbsp;, any</LI> <LI><LI-PRODUCT title="Qlik Sense Desktop" id="qlikSenseDesktop"></LI-PRODUCT>&nbsp;</LI> <LI><LI-PRODUCT title="Qlik Sense Business" id="qlikSenseBusiness"></LI-PRODUCT>&nbsp;<BR />&nbsp;</LI> </UL> <H4 class="qlik-migrated-tkb-headings">Cause:</H4> <P><BR />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.</P> <P>&nbsp;</P> <H4 class="qlik-migrated-tkb-headings">Resolution:</H4> <P><BR />To get the desired result we have to use the TOTAL qualifier in the RowNo() function as shown below.<BR /><BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="use the TOTAL qualifier in the RowNo() function.png" style="width: 550px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/52057i3A2B747669CF7DE2/image-size/large?v=v2&amp;px=999" role="button" title="use the TOTAL qualifier in the RowNo() function.png" alt="use the TOTAL qualifier in the RowNo() function.png" /></span></P> Tue, 10 May 2022 19:23:50 GMT https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-RowNo-on-a-Pivot-Table/ta-p/1710219 Sonja_Bauernfeind 2022-05-10T19:23:50Z