topic Re: When I use a Expression to Sort a field, Position is changing in QlikView https://community.qlik.com/t5/QlikView/When-I-use-a-Expression-to-Sort-a-field-Position-is-changing/m-p/881709#M307613 <HTML><HEAD></HEAD><BODY><P>Gysbert,</P><P></P><P>Thank you. It works</P></BODY></HTML> Wed, 22 Apr 2015 10:56:54 GMT 2015-04-22T10:56:54Z When I use a Expression to Sort a field, Position is changing https://community.qlik.com/t5/QlikView/When-I-use-a-Expression-to-Sort-a-field-Position-is-changing/m-p/881707#M307611 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I have Month name and want to sort it by Month Number.</P><P></P><P>So when displaying I am displaying Month Name and when in sort using expression MonthofYear which is nothing but number 1 to 12.</P><P>It is working fine but position is changing when i select any month. For example If I select Jan, Jan will be star displaying at the end.</P><P></P><P>I don't want this want to freeze the position of each value&nbsp; like Jan Feb to Dec.</P><P></P><P>Please see screenshot attached</P></BODY></HTML> Wed, 22 Apr 2015 08:46:31 GMT https://community.qlik.com/t5/QlikView/When-I-use-a-Expression-to-Sort-a-field-Position-is-changing/m-p/881707#M307611 2015-04-22T08:46:31Z Re: When I use a Expression to Sort a field, Position is changing https://community.qlik.com/t5/QlikView/When-I-use-a-Expression-to-Sort-a-field-Position-is-changing/m-p/881708#M307612 <HTML><HEAD></HEAD><BODY><P>Sort by the expression only(<STRONG>{1}</STRONG>MonthofYear) instead. The {1} will prevent the selection from influencing the sort expression.</P></BODY></HTML> Wed, 22 Apr 2015 08:51:09 GMT https://community.qlik.com/t5/QlikView/When-I-use-a-Expression-to-Sort-a-field-Position-is-changing/m-p/881708#M307612 Gysbert_Wassenaar 2015-04-22T08:51:09Z Re: When I use a Expression to Sort a field, Position is changing https://community.qlik.com/t5/QlikView/When-I-use-a-Expression-to-Sort-a-field-Position-is-changing/m-p/881709#M307613 <HTML><HEAD></HEAD><BODY><P>Gysbert,</P><P></P><P>Thank you. It works</P></BODY></HTML> Wed, 22 Apr 2015 10:56:54 GMT https://community.qlik.com/t5/QlikView/When-I-use-a-Expression-to-Sort-a-field-Position-is-changing/m-p/881709#M307613 2015-04-22T10:56:54Z