topic Sort LEgend in a Chart in QlikView https://community.qlik.com/t5/QlikView/Sort-LEgend-in-a-Chart/m-p/226334#M78540 <HTML><HEAD></HEAD><BODY><P style="line-height: normal; margin: 0in 0in 6pt;">I have a chart with a single dimension and 16 expressions. There are 8 sales expressions (one for each of our locations) and 8 profit expressions (again, one for each location). The end user selects a location and an option (sales and/or profit), and the (conditional) expressions show up on the chart - great! However, in QV 8.5, the legend is sorted by order of the expressions. I can change the legend LABEL to not appear based on GetFieldSelections function, (but the symbol still appears), yet I cannot sort the legend values. Any direction would be greatly appreciated.</P><P style="margin: 0in 0in 10pt;"></P></BODY></HTML> Thu, 28 Jan 2010 20:37:26 GMT 2010-01-28T20:37:26Z Sort LEgend in a Chart https://community.qlik.com/t5/QlikView/Sort-LEgend-in-a-Chart/m-p/226334#M78540 <HTML><HEAD></HEAD><BODY><P style="line-height: normal; margin: 0in 0in 6pt;">I have a chart with a single dimension and 16 expressions. There are 8 sales expressions (one for each of our locations) and 8 profit expressions (again, one for each location). The end user selects a location and an option (sales and/or profit), and the (conditional) expressions show up on the chart - great! However, in QV 8.5, the legend is sorted by order of the expressions. I can change the legend LABEL to not appear based on GetFieldSelections function, (but the symbol still appears), yet I cannot sort the legend values. Any direction would be greatly appreciated.</P><P style="margin: 0in 0in 10pt;"></P></BODY></HTML> Thu, 28 Jan 2010 20:37:26 GMT https://community.qlik.com/t5/QlikView/Sort-LEgend-in-a-Chart/m-p/226334#M78540 2010-01-28T20:37:26Z Sort LEgend in a Chart https://community.qlik.com/t5/QlikView/Sort-LEgend-in-a-Chart/m-p/226335#M78541 <HTML><HEAD></HEAD><BODY><P>Understand that you currently use expressions like SUM(IF(Location = 'XXX', Sales)). Think it makes more sense to use the location as a dimension, for which you may define sorting-options as per an expression and to have only the expression SUM(Sales).</P><P>HTH<BR />Peter</P></BODY></HTML> Thu, 28 Jan 2010 22:02:48 GMT https://community.qlik.com/t5/QlikView/Sort-LEgend-in-a-Chart/m-p/226335#M78541 prieper 2010-01-28T22:02:48Z Sort LEgend in a Chart https://community.qlik.com/t5/QlikView/Sort-LEgend-in-a-Chart/m-p/226336#M78542 <HTML><HEAD></HEAD><BODY><P>thank you very much for responding, I will mull this over... It's appreciated!</P></BODY></HTML> Thu, 28 Jan 2010 22:26:00 GMT https://community.qlik.com/t5/QlikView/Sort-LEgend-in-a-Chart/m-p/226336#M78542 2010-01-28T22:26:00Z