https://community.qlik.com/t5/QlikView/Need-help-on-Qlik-column-sorting/m-p/1979342#M1220931 <P>You'll need to separate the year from the Primary Name field first, then sort Year descending and Name ascending.</P> <P>One possible way is to create a Year and Name Dimension in a straight table, or directly in the script;</P> <P>Left([Primary Name],4) as Year</P> <P>Right([Primary Name], Len([Primary Name]) - Index([Primary Name], ' ')) as Name</P> <P>[Price List]</P> <P>JohnInSD</P> <P>(aka johncaqc)</P> Fri, 09 Sep 2022 15:36:23 GMT Anonymous 2022-09-09T15:36:23Z https://community.qlik.com/t5/QlikView/Need-help-on-Qlik-column-sorting/m-p/1979202#M1220925 <P>Hello Qlik Wizards,</P> <P>I have a requirement to sort a column by latest year on top. After sorting it by Year need to sort the rest of the characters in alphabetical order.&nbsp;</P> <P>I have provided the sample data here.</P> <TABLE width="364"> <TBODY> <TR> <TD width="295">Primary Name</TD> <TD width="69">List Price</TD> </TR> <TR> <TD>2005 MONTREAL MAINE PRIMARY</TD> <TD>$ 46.50</TD> </TR> <TR> <TD>2006 BNSF AC 4400 CONTRACT</TD> <TD>$ 50.00</TD> </TR> <TR> <TD>2006 CERREJON PARTS CONTRACT</TD> <TD>$ 54.66</TD> </TR> <TR> <TD>2006 KCS US MSA PARTS CONTRACT</TD> <TD>$ 52.84</TD> </TR> <TR> <TD>2007 CERREJON PARTS CONTRACT</TD> <TD>$ 56.24</TD> </TR> <TR> <TD>2007 CN PRIMARY</TD> <TD>$ 53.88</TD> </TR> <TR> <TD>2007 COMILOG PRIMARY</TD> <TD>$ 34.37</TD> </TR> <TR> <TD>2007 KCS US MSA PARTS CONTRACT</TD> <TD>$ 55.16</TD> </TR> <TR> <TD>2007 ZHORGA</TD> <TD>$ 54.14</TD> </TR> <TR> <TD>2008 AMTRAK NONCONTRACT PARTS</TD> <TD>$ 38.89</TD> </TR> <TR> <TD>2008 BNSF AC 4400 CONTRACT</TD> <TD>$ 51.85</TD> </TR> <TR> <TD>2008 CERREJON PARTS CONTRACT</TD> <TD>$ 68.05</TD> </TR> <TR> <TD>2008 KCS US MSA PARTS CONTRACT</TD> <TD>$ 57.81</TD> </TR> <TR> <TD>2008 M&amp;S DIST PRICE</TD> <TD>$ 58.99</TD> </TR> <TR> <TD>2008 MONTREAL MAINE PRIMARY</TD> <TD>$ 57.03</TD> </TR> <TR> <TD>2008 QTR PRIMARY</TD> <TD>$ 32.15</TD> </TR> <TR> <TD>2008 RAILAMERICA CONTRACT</TD> <TD>$ 34.48</TD> </TR> <TR> <TD>2009 BNSF AC4400 CONTRACT</TD> <TD>$ 56.15</TD> </TR> <TR> <TD>2009 CERREJON PARTS CONTRACT</TD> <TD>$ 64.65</TD> </TR> <TR> <TD>2009 COMILOG CONTRACT</TD> <TD>$ 39.96</TD> </TR> <TR> <TD>2009 KAZ TRANSFER PRICE LIST</TD> <TD>$ 18.54</TD> </TR> <TR> <TD>2009 TRANSIT</TD> <TD>$ 65.28</TD> </TR> <TR> <TD>2010 AMTRAK NONCONTRACT PARTS</TD> <TD>$ 39.78</TD> </TR> <TR> <TD>2010 BNSF AC4400 CONTRACT</TD> <TD>$ 56.94</TD> </TR> <TR> <TD>2010 CERREJON PARTS CONTRACT</TD> <TD>$ 66.24</TD> </TR> <TR> <TD>2010 KAZ PRICE LIST</TD> <TD>$ 13.72</TD> </TR> <TR> <TD>2010 MONTREAL MAINE PRIMARY</TD> <TD>$ 58.34</TD> </TR> <TR> <TD>2010 RAILAMERICA CONTRACT</TD> <TD>$ 35.57</TD> </TR> <TR> <TD>2010 TRANSIT</TD> <TD>$ 68.54</TD> </TR> <TR> <TD>2010 UGL LTPA CONTRACT</TD> <TD>$ 46.77</TD> </TR> <TR> <TD>2011 AMTRAK NONCONTRACT PARTS</TD> <TD>$ 40.58</TD> </TR> <TR> <TD>2011 AMTRAK NONCONTRACT PARTS - 2H</TD> <TD>$ 42.20</TD> </TR> <TR> <TD>2011 CONTRACT BNSF AC4400</TD> <TD>$ 55.97</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Can anyone help to solve this sorting issue.</P> <P>&nbsp;</P> <P>Thanks,</P> <P>Praveen</P> Fri, 09 Sep 2022 10:54:34 GMT https://community.qlik.com/t5/QlikView/Need-help-on-Qlik-column-sorting/m-p/1979202#M1220925 praveensprabhu 2022-09-09T10:54:34Z https://community.qlik.com/t5/QlikView/Need-help-on-Qlik-column-sorting/m-p/1979342#M1220931 <P>You'll need to separate the year from the Primary Name field first, then sort Year descending and Name ascending.</P> <P>One possible way is to create a Year and Name Dimension in a straight table, or directly in the script;</P> <P>Left([Primary Name],4) as Year</P> <P>Right([Primary Name], Len([Primary Name]) - Index([Primary Name], ' ')) as Name</P> <P>[Price List]</P> <P>JohnInSD</P> <P>(aka johncaqc)</P> Fri, 09 Sep 2022 15:36:23 GMT https://community.qlik.com/t5/QlikView/Need-help-on-Qlik-column-sorting/m-p/1979342#M1220931 Anonymous 2022-09-09T15:36:23Z