topic Month order in list in QlikView https://community.qlik.com/t5/QlikView/Month-order-in-list/m-p/465202#M173747 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a list box in which am showing months. I have two fields comming my load script for month - One has months names(Jan, Feb etc) and the other has numeric values ofr months(1,2 etc). In the list, am using the month name(Jan, Feb) but sorting by the month number to get them sorted correctly and it workes fine.</P><P></P><P>However, when I slect a month in the list box, the order is gone. Any thoughts on how to fix this? Thanks in advance!</P></BODY></HTML> Sat, 23 Feb 2013 04:08:13 GMT 2013-02-23T04:08:13Z Month order in list https://community.qlik.com/t5/QlikView/Month-order-in-list/m-p/465202#M173747 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a list box in which am showing months. I have two fields comming my load script for month - One has months names(Jan, Feb etc) and the other has numeric values ofr months(1,2 etc). In the list, am using the month name(Jan, Feb) but sorting by the month number to get them sorted correctly and it workes fine.</P><P></P><P>However, when I slect a month in the list box, the order is gone. Any thoughts on how to fix this? Thanks in advance!</P></BODY></HTML> Sat, 23 Feb 2013 04:08:13 GMT https://community.qlik.com/t5/QlikView/Month-order-in-list/m-p/465202#M173747 2013-02-23T04:08:13Z Re: Month order in list https://community.qlik.com/t5/QlikView/Month-order-in-list/m-p/465203#M173748 <HTML><HEAD></HEAD><BODY><P>so you must have used sort expression to sort the Month name by your Month Number..</P><P></P><P>Use sort expressions as = sum ({1} Month number Field)</P><P></P><P>that will do it....</P></BODY></HTML> Sat, 23 Feb 2013 04:12:56 GMT https://community.qlik.com/t5/QlikView/Month-order-in-list/m-p/465203#M173748 phaneendra_kunc 2013-02-23T04:12:56Z Re: Month order in list https://community.qlik.com/t5/QlikView/Month-order-in-list/m-p/465204#M173749 <HTML><HEAD></HEAD><BODY><P>Thank you - that did the trick. Can you please explain me how it works?</P></BODY></HTML> Sat, 23 Feb 2013 04:30:57 GMT https://community.qlik.com/t5/QlikView/Month-order-in-list/m-p/465204#M173749 2013-02-23T04:30:57Z Re: Month order in list https://community.qlik.com/t5/QlikView/Month-order-in-list/m-p/465205#M173750 <HTML><HEAD></HEAD><BODY><P>It is just a set statement...</P><P></P><P>1 means ignore current selections.....</P><P>In your case if you choose any month name that will filters the Month number according to your selection...so for the rest of the months that number will be NULL/Invalid...</P><P></P><P></P><P>Hit F1 and search for Set Analsysis...<A class="active_link" name="kanchor1044"></A></P><P></P><P><SPAN class="Bold">sum(</SPAN> {$} Sales <SPAN class="Bold">)</SPAN><BR />returns sales for the current selection, i.e. the same as sum(Sales). </P><P><SPAN class="Bold">sum(</SPAN> {$1} Sales <SPAN class="Bold">)</SPAN><BR />returns sales for the previous selection. </P><P><SPAN class="Bold">sum(</SPAN> {$_2} Sales <SPAN class="Bold">)</SPAN><BR />returns sales for the 2nd next selection, i.e. two steps forward. Only relevant if you just made two <SPAN class="Bold">Back</SPAN> operations. </P><P><SPAN class="Bold">sum(</SPAN> {1} Sales <SPAN class="Bold">)</SPAN><BR />returns total sales within the application, disregarding the selection but not the dimension. If used in a chart with e.g. Products as dimension, each product will get a different value. </P><P><SPAN class="Bold">sum(</SPAN> {1} <SPAN class="Bold">Total</SPAN> Sales <SPAN class="Bold">)</SPAN><BR />returns total sales within the application, disregarding both selection and dimension. I.e. the same as sum(<SPAN class="Bold">All</SPAN> Sales). </P><P><SPAN class="Bold">sum(</SPAN> {BM01} Sales <SPAN class="Bold">)</SPAN><BR />returns sales for the bookmark BM01. </P><P><SPAN class="Bold">sum(</SPAN> {MyBookMark} Sales<SPAN class="Bold"> )</SPAN><BR />returns sales for the bookmark MyBookMark. </P><P><SPAN class="Bold">sum(</SPAN>{Server\BM01} Sales<SPAN class="Bold">)</SPAN><BR />returns the sales for the server bookmark BM01. </P><P><SPAN class="Bold">sum(</SPAN>{Document\MyBookmark}Sales<SPAN class="Bold">)</SPAN><BR />returns the sales for the document bookmark MyBookmark. </P><P></P><P></P><P></P><P>And mark this thread as answered if the solution works for you. so that community people will know where to find the answers for similar answers...!!!</P><P></P><P>Happy Learning <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Sat, 23 Feb 2013 04:42:58 GMT https://community.qlik.com/t5/QlikView/Month-order-in-list/m-p/465205#M173750 phaneendra_kunc 2013-02-23T04:42:58Z