topic Automate sorting in QlikView https://community.qlik.com/t5/QlikView/Automate-sorting/m-p/411965#M489592 <HTML><HEAD></HEAD><BODY><P>I have a chart with an expression for each month. My sort order is January, then February, then March, etc. When I select a month (say October) I have a condition that hides any month that is not equal to the selection. However the sort order is still based on January.</P><P></P><P>Is there a way, in my example above, to keep the sort order by month, but when I select on October it sorts on October, then when I deselect October it goes back to sorting by Jan, then Feb, then March, etc.?</P><P></P><P>Thanks in advance for any help.</P></BODY></HTML> Wed, 07 Nov 2012 15:35:58 GMT zagzebski 2012-11-07T15:35:58Z Automate sorting https://community.qlik.com/t5/QlikView/Automate-sorting/m-p/411965#M489592 <HTML><HEAD></HEAD><BODY><P>I have a chart with an expression for each month. My sort order is January, then February, then March, etc. When I select a month (say October) I have a condition that hides any month that is not equal to the selection. However the sort order is still based on January.</P><P></P><P>Is there a way, in my example above, to keep the sort order by month, but when I select on October it sorts on October, then when I deselect October it goes back to sorting by Jan, then Feb, then March, etc.?</P><P></P><P>Thanks in advance for any help.</P></BODY></HTML> Wed, 07 Nov 2012 15:35:58 GMT https://community.qlik.com/t5/QlikView/Automate-sorting/m-p/411965#M489592 zagzebski 2012-11-07T15:35:58Z Re: Automate sorting https://community.qlik.com/t5/QlikView/Automate-sorting/m-p/411966#M489593 <HTML><HEAD></HEAD><BODY><P>What are your current settings in Chart Properties &gt; Sort?</P></BODY></HTML> Thu, 08 Nov 2012 14:34:30 GMT https://community.qlik.com/t5/QlikView/Automate-sorting/m-p/411966#M489593 2012-11-08T14:34:30Z Re: Automate sorting https://community.qlik.com/t5/QlikView/Automate-sorting/m-p/411967#M489594 <HTML><HEAD></HEAD><BODY><P>Jan - numeric value descending, then Feb - numeric value descending, then Mar - numeric value descending, etc.</P><P></P><P>Also allow interactive sort is checked.</P></BODY></HTML> Thu, 08 Nov 2012 14:43:54 GMT https://community.qlik.com/t5/QlikView/Automate-sorting/m-p/411967#M489594 zagzebski 2012-11-08T14:43:54Z Re: Automate sorting https://community.qlik.com/t5/QlikView/Automate-sorting/m-p/411968#M489595 <HTML><HEAD></HEAD><BODY><P>You can use variables in the Sort expression.&nbsp; Do you have a sample file?</P></BODY></HTML> Thu, 08 Nov 2012 22:06:35 GMT https://community.qlik.com/t5/QlikView/Automate-sorting/m-p/411968#M489595 2012-11-08T22:06:35Z