https://community.qlik.com/t5/App-Development/How-to-create-ranged-table/m-p/1905433#M74652 <P>I have a table with two columns, on of ID and the other of numbers.&nbsp;</P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD width="50%" height="25px">ID</TD> <TD width="50%" height="25px">NUM</TD> </TR> <TR> <TD height="25px">8997765</TD> <TD height="25px">0</TD> </TR> <TR> <TD height="25px">8899654</TD> <TD height="25px">1</TD> </TR> <TR> <TD width="50%" height="25px">8889777</TD> <TD width="50%" height="25px">2</TD> </TR> <TR> <TD>8888554</TD> <TD>9</TD> </TR> <TR> <TD width="50%" height="25px">8889776</TD> <TD width="50%" height="25px">50</TD> </TR> <TR> <TD width="50%" height="25px">8877954</TD> <TD width="50%" height="25px">100</TD> </TR> <TR> <TD>8885532</TD> <TD>105</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>How can&nbsp; i turn it to this?</P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD width="50%">COUNT(ID)</TD> <TD width="50%">NUM (fixed string)</TD> </TR> <TR> <TD>3</TD> <TD>0-9</TD> </TR> <TR> <TD width="50%">2</TD> <TD width="50%">9-99</TD> </TR> <TR> <TD width="50%">2</TD> <TD width="50%">100+</TD> </TR> </TBODY> </TABLE> Tue, 15 Mar 2022 14:56:20 GMT YanivZi 2022-03-15T14:56:20Z https://community.qlik.com/t5/App-Development/How-to-create-ranged-table/m-p/1905433#M74652 <P>I have a table with two columns, on of ID and the other of numbers.&nbsp;</P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD width="50%" height="25px">ID</TD> <TD width="50%" height="25px">NUM</TD> </TR> <TR> <TD height="25px">8997765</TD> <TD height="25px">0</TD> </TR> <TR> <TD height="25px">8899654</TD> <TD height="25px">1</TD> </TR> <TR> <TD width="50%" height="25px">8889777</TD> <TD width="50%" height="25px">2</TD> </TR> <TR> <TD>8888554</TD> <TD>9</TD> </TR> <TR> <TD width="50%" height="25px">8889776</TD> <TD width="50%" height="25px">50</TD> </TR> <TR> <TD width="50%" height="25px">8877954</TD> <TD width="50%" height="25px">100</TD> </TR> <TR> <TD>8885532</TD> <TD>105</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>How can&nbsp; i turn it to this?</P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD width="50%">COUNT(ID)</TD> <TD width="50%">NUM (fixed string)</TD> </TR> <TR> <TD>3</TD> <TD>0-9</TD> </TR> <TR> <TD width="50%">2</TD> <TD width="50%">9-99</TD> </TR> <TR> <TD width="50%">2</TD> <TD width="50%">100+</TD> </TR> </TBODY> </TABLE> Tue, 15 Mar 2022 14:56:20 GMT https://community.qlik.com/t5/App-Development/How-to-create-ranged-table/m-p/1905433#M74652 YanivZi 2022-03-15T14:56:20Z https://community.qlik.com/t5/App-Development/How-to-create-ranged-table/m-p/1905528#M74655 <P>Hi&nbsp;</P> <P>May be with a calculated dimension based on NUM :</P> <P>=if(NUM&lt;9,dual('0-9',1),<BR />if(NUM&lt;99,dual('10-99',2),<BR />if(NUM&gt;=100,dual('100+',3))))</P> <P>i used if statement aned dual function to make order by 0-9 10-99 and 100+ easier&nbsp;</P> <P>&nbsp;</P> <P>mesure is count(ID)&nbsp;</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="brunobertels_0-1647363373292.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/74532i28AED76DEF10784E/image-size/medium?v=v2&amp;px=400" role="button" title="brunobertels_0-1647363373292.png" alt="brunobertels_0-1647363373292.png" /></span></P> <P>&nbsp;</P> Tue, 15 Mar 2022 16:56:20 GMT https://community.qlik.com/t5/App-Development/How-to-create-ranged-table/m-p/1905528#M74655 brunobertels 2022-03-15T16:56:20Z