topic Re: How to sort a measure by dimension within a table/bar chart in App Development https://community.qlik.com/t5/App-Development/How-to-sort-a-measure-by-dimension-within-a-table-bar-chart/m-p/2490406#M101927 <P>found a way, is to sort by expression, descending,&nbsp;(4-type)*999999999+sum(value)</P> <P>and the chart will look like this</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="EdyTan_1-1730529715245.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/173722i107A6F46622312C1/image-size/medium?v=v2&amp;px=400" role="button" title="EdyTan_1-1730529715245.png" alt="EdyTan_1-1730529715245.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Sat, 02 Nov 2024 06:42:14 GMT EdyTan 2024-11-02T06:42:14Z How to sort a measure by dimension within a table/bar chart https://community.qlik.com/t5/App-Development/How-to-sort-a-measure-by-dimension-within-a-table-bar-chart/m-p/2490403#M101926 <P>Assuming I have the following data:</P> <TABLE cellspacing="0" cellpadding="0"> <TBODY> <TR> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">type</FONT></P> </TD> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">row</FONT></P> </TD> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">value</FONT></P> </TD> </TR> <TR> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">1</FONT></P> </TD> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">A</FONT></P> </TD> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">10</FONT></P> </TD> </TR> <TR> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">1</FONT></P> </TD> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">B</FONT></P> </TD> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">20</FONT></P> </TD> </TR> <TR> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">1</FONT></P> </TD> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">C</FONT></P> </TD> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">30</FONT></P> </TD> </TR> <TR> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">1</FONT></P> </TD> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">D</FONT></P> </TD> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">40</FONT></P> </TD> </TR> <TR> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">2</FONT></P> </TD> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">10</FONT></P> </TD> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">50</FONT></P> </TD> </TR> <TR> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">2</FONT></P> </TD> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">11</FONT></P> </TD> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">60</FONT></P> </TD> </TR> <TR> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">3</FONT></P> </TD> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">Total</FONT></P> </TD> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">100</FONT></P> </TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Is it possible create a table/bar chart which sort by type followed by sum(value).&nbsp; The result is like this:</P> <TABLE cellspacing="0" cellpadding="0"> <TBODY> <TR> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">row</FONT></P> </TD> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">sum(value)</FONT></P> </TD> </TR> <TR> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">D</FONT></P> </TD> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">40</FONT></P> </TD> </TR> <TR> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">C</FONT></P> </TD> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">30</FONT></P> </TD> </TR> <TR> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">B</FONT></P> </TD> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">20</FONT></P> </TD> </TR> <TR> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">A</FONT></P> </TD> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">10</FONT></P> </TD> </TR> <TR> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">11</FONT></P> </TD> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">60</FONT></P> </TD> </TR> <TR> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">10</FONT></P> </TD> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">50</FONT></P> </TD> </TR> <TR> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">Total</FONT></P> </TD> <TD valign="bottom"> <P><FONT face="Arial" size="2" color="#000000">100</FONT></P> </TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>&nbsp;</P> Sat, 02 Nov 2024 06:24:23 GMT https://community.qlik.com/t5/App-Development/How-to-sort-a-measure-by-dimension-within-a-table-bar-chart/m-p/2490403#M101926 EdyTan 2024-11-02T06:24:23Z Re: How to sort a measure by dimension within a table/bar chart https://community.qlik.com/t5/App-Development/How-to-sort-a-measure-by-dimension-within-a-table-bar-chart/m-p/2490406#M101927 <P>found a way, is to sort by expression, descending,&nbsp;(4-type)*999999999+sum(value)</P> <P>and the chart will look like this</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="EdyTan_1-1730529715245.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/173722i107A6F46622312C1/image-size/medium?v=v2&amp;px=400" role="button" title="EdyTan_1-1730529715245.png" alt="EdyTan_1-1730529715245.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Sat, 02 Nov 2024 06:42:14 GMT https://community.qlik.com/t5/App-Development/How-to-sort-a-measure-by-dimension-within-a-table-bar-chart/m-p/2490406#M101927 EdyTan 2024-11-02T06:42:14Z