topic RowNo(TOTAL) does not work in QlikView https://community.qlik.com/t5/QlikView/RowNo-TOTAL-does-not-work/m-p/1267147#M849656 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I want to show the row no of a table and I ma using RowNo(TOTAL) in the expression side. But it shows nothing as below</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/155886_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>Please let me know what to correct?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT ananyaghosh 2020-11-25T16:16:04Z RowNo(TOTAL) does not work https://community.qlik.com/t5/QlikView/RowNo-TOTAL-does-not-work/m-p/1267147#M849656 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I want to show the row no of a table and I ma using RowNo(TOTAL) in the expression side. But it shows nothing as below</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/155886_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>Please let me know what to correct?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/RowNo-TOTAL-does-not-work/m-p/1267147#M849656 ananyaghosh 2020-11-25T16:16:04Z Re: RowNo(TOTAL) does not work https://community.qlik.com/t5/QlikView/RowNo-TOTAL-does-not-work/m-p/1267148#M849657 <HTML><HEAD></HEAD><BODY><P>Can you post a screenshot of the expression on the expression tab of the chart properties?</P></BODY></HTML> Fri, 10 Mar 2017 12:08:30 GMT https://community.qlik.com/t5/QlikView/RowNo-TOTAL-does-not-work/m-p/1267148#M849657 sunny_talwar 2017-03-10T12:08:30Z Re: RowNo(TOTAL) does not work https://community.qlik.com/t5/QlikView/RowNo-TOTAL-does-not-work/m-p/1267149#M849659 <HTML><HEAD></HEAD><BODY><P>If you are using it as a calculated dimension, try like: <EM>= Aggr(RowNo(), [%Office Key]) </EM>and if you are looking for total number of rows, try = <EM>Aggr(NoOfRows(), <EM style="font-size: 13.3333px;">[%Office Key])</EM></EM></P></BODY></HTML> Fri, 10 Mar 2017 12:16:39 GMT https://community.qlik.com/t5/QlikView/RowNo-TOTAL-does-not-work/m-p/1267149#M849659 tresB 2017-03-10T12:16:39Z Re: RowNo(TOTAL) does not work https://community.qlik.com/t5/QlikView/RowNo-TOTAL-does-not-work/m-p/1267150#M849660 <HTML><HEAD></HEAD><BODY><P>this needs to be added as an expression, i think you trying to add it as a calculated dimension</P></BODY></HTML> Fri, 10 Mar 2017 12:31:42 GMT https://community.qlik.com/t5/QlikView/RowNo-TOTAL-does-not-work/m-p/1267150#M849660 vinieme12 2017-03-10T12:31:42Z