https://community.qlik.com/t5/App-Development/count-dimension-in-straight-table/m-p/1817776#M66991 <P>Hi Team,<BR /><BR />I have a table in which I have instance_id, Reg_no, and amount columns.</P><P>&nbsp;</P><P>I want to show the count of Reg_no below Reg_no dimension. Is it possible?</P><P>Like:</P><P>instance_id&nbsp; &nbsp; &nbsp; &nbsp; Reg_no&nbsp; &nbsp; &nbsp;Sum(amount)</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; a121&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;b131&nbsp; &nbsp; &nbsp; &nbsp; 150</P><P>3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;t511&nbsp; &nbsp; &nbsp; &nbsp; 100</P><P>&nbsp;Total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 300&nbsp; &nbsp; &nbsp; &nbsp;</P><P>&nbsp;</P><P>Thanks,</P><P>Narender</P> Fri, 25 Jun 2021 06:11:43 GMT narender123 2021-06-25T06:11:43Z https://community.qlik.com/t5/App-Development/count-dimension-in-straight-table/m-p/1817776#M66991 <P>Hi Team,<BR /><BR />I have a table in which I have instance_id, Reg_no, and amount columns.</P><P>&nbsp;</P><P>I want to show the count of Reg_no below Reg_no dimension. Is it possible?</P><P>Like:</P><P>instance_id&nbsp; &nbsp; &nbsp; &nbsp; Reg_no&nbsp; &nbsp; &nbsp;Sum(amount)</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; a121&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;b131&nbsp; &nbsp; &nbsp; &nbsp; 150</P><P>3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;t511&nbsp; &nbsp; &nbsp; &nbsp; 100</P><P>&nbsp;Total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 300&nbsp; &nbsp; &nbsp; &nbsp;</P><P>&nbsp;</P><P>Thanks,</P><P>Narender</P> Fri, 25 Jun 2021 06:11:43 GMT https://community.qlik.com/t5/App-Development/count-dimension-in-straight-table/m-p/1817776#M66991 narender123 2021-06-25T06:11:43Z https://community.qlik.com/t5/App-Development/count-dimension-in-straight-table/m-p/1817868#M66999 <P>Hi&nbsp;<SPAN>Narender,</SPAN></P><P>You can create "Reg_no" as a measure in the table, and then in the "Totals function" drop-down in the measure, select "Count".</P><P>Regards,</P><P>&nbsp;</P><P>Paul</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="paulselousyoriz_0-1624618403331.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/57538i60B25D0754EAF800/image-size/medium?v=v2&amp;px=400" role="button" title="paulselousyoriz_0-1624618403331.png" alt="paulselousyoriz_0-1624618403331.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="paulselousyoriz_1-1624618440837.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/57539iF6C1A3F2AC23DDD8/image-size/medium?v=v2&amp;px=400" role="button" title="paulselousyoriz_1-1624618440837.png" alt="paulselousyoriz_1-1624618440837.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Fri, 25 Jun 2021 10:54:44 GMT https://community.qlik.com/t5/App-Development/count-dimension-in-straight-table/m-p/1817868#M66999 paulselousyoriz 2021-06-25T10:54:44Z