topic Re: layout in QlikView https://community.qlik.com/t5/QlikView/layout/m-p/1073621#M525670 <HTML><HEAD></HEAD><BODY><P>I think <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">the currentselections box sorts the data in the order it was loaded and&nbsp; no way to change the sorting order in the currentselections box other than doing the sorting in the load script at back end.</SPAN></P><P></P><P>-Hirish</P></BODY></HTML> Wed, 13 Jan 2016 06:44:52 GMT HirisH_V7 2016-01-13T06:44:52Z layout https://community.qlik.com/t5/QlikView/layout/m-p/1073616#M525665 <HTML><HEAD></HEAD><BODY><P> How to sort in current selection box for rolling 4 months like oct2015,nov2015,dec2015,jan2016 coming in random order</P></BODY></HTML> Tue, 12 Jan 2016 13:45:47 GMT https://community.qlik.com/t5/QlikView/layout/m-p/1073616#M525665 2016-01-12T13:45:47Z Re: layout https://community.qlik.com/t5/QlikView/layout/m-p/1073617#M525666 <HTML><HEAD></HEAD><BODY><P>No need to do anything.</P><P></P><P>By default it will sort as per data<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 12 Jan 2016 13:50:47 GMT https://community.qlik.com/t5/QlikView/layout/m-p/1073617#M525666 Anonymous 2016-01-12T13:50:47Z Re: layout https://community.qlik.com/t5/QlikView/layout/m-p/1073618#M525667 <HTML><HEAD></HEAD><BODY><P>could you post your sample app?</P></BODY></HTML> Tue, 12 Jan 2016 14:00:51 GMT https://community.qlik.com/t5/QlikView/layout/m-p/1073618#M525667 2016-01-12T14:00:51Z Re: layout https://community.qlik.com/t5/QlikView/layout/m-p/1073619#M525668 <HTML><HEAD></HEAD><BODY><P>Check this post:</P><P></P><P><A href="https://community.qlik.com/docs/DOC-4252">Calculating rolling n-period totals, averages or other aggregations</A></P><P></P><P>Regards, </P><P>MB</P></BODY></HTML> Tue, 12 Jan 2016 14:05:00 GMT https://community.qlik.com/t5/QlikView/layout/m-p/1073619#M525668 miguelbraga 2016-01-12T14:05:00Z Re: layout https://community.qlik.com/t5/QlikView/layout/m-p/1073620#M525669 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Since you said you're using Concat function, why not sort your concat using the Sort Weight in the Concat() function itself to sort it</P><P>&nbsp; <SPAN class="script_token">Concat (</SPAN> <SPAN class="bnf_token">[ distinct ] string [, delimiter [, sort-weight]]</SPAN> <SPAN class="script_token">)</SPAN>&nbsp; </P></BODY></HTML> Tue, 12 Jan 2016 14:35:32 GMT https://community.qlik.com/t5/QlikView/layout/m-p/1073620#M525669 Gabriel 2016-01-12T14:35:32Z Re: layout https://community.qlik.com/t5/QlikView/layout/m-p/1073621#M525670 <HTML><HEAD></HEAD><BODY><P>I think <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">the currentselections box sorts the data in the order it was loaded and&nbsp; no way to change the sorting order in the currentselections box other than doing the sorting in the load script at back end.</SPAN></P><P></P><P>-Hirish</P></BODY></HTML> Wed, 13 Jan 2016 06:44:52 GMT https://community.qlik.com/t5/QlikView/layout/m-p/1073621#M525670 HirisH_V7 2016-01-13T06:44:52Z