topic Re: How to sort dimension by cyclic group expression in QlikView https://community.qlik.com/t5/QlikView/How-to-sort-dimension-by-cyclic-group-expression/m-p/932650#M468274 <HTML><HEAD></HEAD><BODY><P>If it is ok to show Product first on the x axis instead of day the you could simply use sort by Y value. </P></BODY></HTML> Fri, 11 Sep 2015 12:33:56 GMT Michiel_QV_Fan 2015-09-11T12:33:56Z How to sort dimension by cyclic group expression https://community.qlik.com/t5/QlikView/How-to-sort-dimension-by-cyclic-group-expression/m-p/932649#M468273 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>In my chart, I have expressions <STRONG>sum(nb_sales)</STRONG> and <STRONG>sum(nb_abo)</STRONG> which are in the same cyclic group and dimensions <STRONG>time</STRONG> and <STRONG>product</STRONG>.</P><P></P><P>Is it possible to sort my dimension "Product" depending of the expression displayed?</P><P></P><P>So:</P><P>If sum(nb_sales) is displayed, I want my Product sorted by sum(nb_sales) desc.</P><P>Il sum(nb_abo) is displayed, <SPAN style="font-size: 13.3333px;">I want my Product sorted by sum(nb_abo) desc.</SPAN></P><P></P><P>See file in example.</P><P></P><P>Thanks &amp; Regards</P></BODY></HTML> Fri, 11 Sep 2015 12:17:36 GMT https://community.qlik.com/t5/QlikView/How-to-sort-dimension-by-cyclic-group-expression/m-p/932649#M468273 sarafamiglietti 2015-09-11T12:17:36Z Re: How to sort dimension by cyclic group expression https://community.qlik.com/t5/QlikView/How-to-sort-dimension-by-cyclic-group-expression/m-p/932650#M468274 <HTML><HEAD></HEAD><BODY><P>If it is ok to show Product first on the x axis instead of day the you could simply use sort by Y value. </P></BODY></HTML> Fri, 11 Sep 2015 12:33:56 GMT https://community.qlik.com/t5/QlikView/How-to-sort-dimension-by-cyclic-group-expression/m-p/932650#M468274 Michiel_QV_Fan 2015-09-11T12:33:56Z Re: How to sort dimension by cyclic group expression https://community.qlik.com/t5/QlikView/How-to-sort-dimension-by-cyclic-group-expression/m-p/932651#M468275 <HTML><HEAD></HEAD><BODY><P>Thanks you for your answer.</P><P></P><P>But in my case I must show day first.</P></BODY></HTML> Fri, 11 Sep 2015 12:50:00 GMT https://community.qlik.com/t5/QlikView/How-to-sort-dimension-by-cyclic-group-expression/m-p/932651#M468275 sarafamiglietti 2015-09-11T12:50:00Z