topic Re: Sorting based on two column values in QlikView https://community.qlik.com/t5/QlikView/Sorting-based-on-two-column-values/m-p/386911#M144482 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Very useful to know. Thank you very much HIC.</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Cheers,</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">DV</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"><A href="http://QlikShare.com">www.QlikShare.com</A></SPAN></P></BODY></HTML> Sun, 07 Oct 2012 10:46:30 GMT IAMDV 2012-10-07T10:46:30Z Sorting based on two column values https://community.qlik.com/t5/QlikView/Sorting-based-on-two-column-values/m-p/386909#M144480 <HTML><HEAD></HEAD><BODY><P>I would like to sort the pivot table based on two column values </P><P>Like consider i will sorting by Number and Alphabet. those Columns will not be part of Dimension or expression.</P><P> Is there any way we use combine two columns and sort it ...</P></BODY></HTML> Fri, 05 Oct 2012 14:44:35 GMT https://community.qlik.com/t5/QlikView/Sorting-based-on-two-column-values/m-p/386909#M144480 2012-10-05T14:44:35Z Re: Sorting based on two column values https://community.qlik.com/t5/QlikView/Sorting-based-on-two-column-values/m-p/386910#M144481 <HTML><HEAD></HEAD><BODY><P>You can create an expression to describe the sort order and use this in the chart properties-&gt;sort-&gt;sort by expression, e.g </P><P>&nbsp;&nbsp; Number*100 + ord(Alphabet)</P><P></P><P>Multiplying by 100 will make the sort by Number first then by Alphabet.</P><P></P><P>HIC</P></BODY></HTML> Fri, 05 Oct 2012 21:24:57 GMT https://community.qlik.com/t5/QlikView/Sorting-based-on-two-column-values/m-p/386910#M144481 hic 2012-10-05T21:24:57Z Re: Sorting based on two column values https://community.qlik.com/t5/QlikView/Sorting-based-on-two-column-values/m-p/386911#M144482 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Very useful to know. Thank you very much HIC.</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Cheers,</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">DV</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"><A href="http://QlikShare.com">www.QlikShare.com</A></SPAN></P></BODY></HTML> Sun, 07 Oct 2012 10:46:30 GMT https://community.qlik.com/t5/QlikView/Sorting-based-on-two-column-values/m-p/386911#M144482 IAMDV 2012-10-07T10:46:30Z