topic Re: Sorting by y-value and then alphabetically in QlikView https://community.qlik.com/t5/QlikView/Sorting-by-y-value-and-then-alphabetically/m-p/640187#M234635 <HTML><HEAD></HEAD><BODY><P>If your expression will be exactly the same (regarding spaces and letter size), QV should use cache ....</P><P>Unfortunetely, as i know, we cant use label from normal expression there ....</P></BODY></HTML> Wed, 04 Jun 2014 22:16:26 GMT 2014-06-04T22:16:26Z Sorting by y-value and then alphabetically https://community.qlik.com/t5/QlikView/Sorting-by-y-value-and-then-alphabetically/m-p/640182#M234630 <HTML><HEAD></HEAD><BODY><P>Hello, guys.</P><P></P><P>I have a simple bar chart with one dimension and one expression. The dimension is sorted by y-value. Since several of the y-values are the same, I'd like the dimension to be further sorted alphabetically but it insists on being unordered inside each y-value group. I've tried sorting the dimension using "Load... Resident... Order by..." in the script to no avail. Does any one know how can I sort by y-value and then alphabetically? Any workaround for this problem?</P><P></P><P>Any help will be greatly appreciated.</P></BODY></HTML> Wed, 04 Jun 2014 21:01:51 GMT https://community.qlik.com/t5/QlikView/Sorting-by-y-value-and-then-alphabetically/m-p/640182#M234630 Anonymous 2014-06-04T21:01:51Z Re: Sorting by y-value and then alphabetically https://community.qlik.com/t5/QlikView/Sorting-by-y-value-and-then-alphabetically/m-p/640183#M234631 <HTML><HEAD></HEAD><BODY><P>Check to sort by expression and by text.</P><P>As expression put the same expression as you use in your chart.</P><P></P><P>reg</P><P>D</P></BODY></HTML> Wed, 04 Jun 2014 21:30:54 GMT https://community.qlik.com/t5/QlikView/Sorting-by-y-value-and-then-alphabetically/m-p/640183#M234631 2014-06-04T21:30:54Z Re: Sorting by y-value and then alphabetically https://community.qlik.com/t5/QlikView/Sorting-by-y-value-and-then-alphabetically/m-p/640184#M234632 <HTML><HEAD></HEAD><BODY><P>Hello my friend.</P><P class="g-unit"><SPAN class="hps" style="font-size: 10pt; line-height: 1.5em;">I never had</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;"> </SPAN><SPAN class="hps" style="font-size: 10pt; line-height: 1.5em;">this problem.</SPAN></P><P class="g-unit"><SPAN class="hps" style="font-size: 10pt; line-height: 1.5em;">See the example.</SPAN></P><DIV><DIV><DIV class="almost_half_cell"><DIV dir="ltr"><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Add <SPAN class="short_text" lang="en"><SPAN class="hps">a</SPAN> <SPAN class="hps">sample</SPAN> <SPAN class="hps">qvw. please.</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><SPAN class="short_text" lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><SPAN class="short_text" lang="en"><SPAN class="hps">Best regards.</SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><SPAN class="short_text" lang="en"><SPAN class="hps">Tonial.<BR /></SPAN></SPAN></SPAN></P></DIV></DIV></DIV></DIV></BODY></HTML> Wed, 04 Jun 2014 21:39:30 GMT https://community.qlik.com/t5/QlikView/Sorting-by-y-value-and-then-alphabetically/m-p/640184#M234632 fernando_tonial 2014-06-04T21:39:30Z Re: Sorting by y-value and then alphabetically https://community.qlik.com/t5/QlikView/Sorting-by-y-value-and-then-alphabetically/m-p/640185#M234633 <HTML><HEAD></HEAD><BODY><P>Hello, Dariusz. Thanks for the reply.</P><P></P><P>Your method is simple and works. The motive I've not thought of it is that there are several conditional expressions in my actual chart and it would be a hassle to create a gigantic sort expression. Any idea of how the sorting could be done without sorting by expression?</P></BODY></HTML> Wed, 04 Jun 2014 22:07:19 GMT https://community.qlik.com/t5/QlikView/Sorting-by-y-value-and-then-alphabetically/m-p/640185#M234633 Anonymous 2014-06-04T22:07:19Z Re: Re: Sorting by y-value and then alphabetically https://community.qlik.com/t5/QlikView/Sorting-by-y-value-and-then-alphabetically/m-p/640186#M234634 <HTML><HEAD></HEAD><BODY><P>Hello, Tonial.</P><P></P><P>I've attached a sample qvw. You can see the problem and Dariusz' solution. But as I explained I'd rather not sort by expression.</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 04 Jun 2014 22:10:04 GMT https://community.qlik.com/t5/QlikView/Sorting-by-y-value-and-then-alphabetically/m-p/640186#M234634 Anonymous 2014-06-04T22:10:04Z Re: Sorting by y-value and then alphabetically https://community.qlik.com/t5/QlikView/Sorting-by-y-value-and-then-alphabetically/m-p/640187#M234635 <HTML><HEAD></HEAD><BODY><P>If your expression will be exactly the same (regarding spaces and letter size), QV should use cache ....</P><P>Unfortunetely, as i know, we cant use label from normal expression there ....</P></BODY></HTML> Wed, 04 Jun 2014 22:16:26 GMT https://community.qlik.com/t5/QlikView/Sorting-by-y-value-and-then-alphabetically/m-p/640187#M234635 2014-06-04T22:16:26Z