topic Re: Display previous month in a listbox in QlikView https://community.qlik.com/t5/QlikView/Display-previous-month-in-a-listbox/m-p/693796#M541914 <HTML><HEAD></HEAD><BODY><P>Thanks for your help.</P></BODY></HTML> Tue, 17 Jun 2014 13:14:50 GMT Anonymous 2014-06-17T13:14:50Z Display previous month in a listbox https://community.qlik.com/t5/QlikView/Display-previous-month-in-a-listbox/m-p/693793#M541911 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>in a listbox months can be selected. When opening, or change worksheets previous month to the current month should be displayed and selected. In the current month of June that would be May. The problem is, that Month is in text format. Do you have any idea? Thanks for help.</P><P></P><P>Regards Stefan</P></BODY></HTML> Tue, 17 Jun 2014 12:19:29 GMT https://community.qlik.com/t5/QlikView/Display-previous-month-in-a-listbox/m-p/693793#M541911 Anonymous 2014-06-17T12:19:29Z Re: Display previous month in a listbox https://community.qlik.com/t5/QlikView/Display-previous-month-in-a-listbox/m-p/693794#M541912 <HTML><HEAD></HEAD><BODY><P>Create a numerical month (or a date using monthstart) field in the script and use that to make the selection in.</P></BODY></HTML> Tue, 17 Jun 2014 12:26:46 GMT https://community.qlik.com/t5/QlikView/Display-previous-month-in-a-listbox/m-p/693794#M541912 Gysbert_Wassenaar 2014-06-17T12:26:46Z Re: Display previous month in a listbox https://community.qlik.com/t5/QlikView/Display-previous-month-in-a-listbox/m-p/693795#M541913 <HTML><HEAD></HEAD><BODY><P>See attached. I have done it for your second sheet.</P><P>=Month(AddMonths(Today(),-1))</P></BODY></HTML> Tue, 17 Jun 2014 12:32:45 GMT https://community.qlik.com/t5/QlikView/Display-previous-month-in-a-listbox/m-p/693795#M541913 tresB 2014-06-17T12:32:45Z Re: Display previous month in a listbox https://community.qlik.com/t5/QlikView/Display-previous-month-in-a-listbox/m-p/693796#M541914 <HTML><HEAD></HEAD><BODY><P>Thanks for your help.</P></BODY></HTML> Tue, 17 Jun 2014 13:14:50 GMT https://community.qlik.com/t5/QlikView/Display-previous-month-in-a-listbox/m-p/693796#M541914 Anonymous 2014-06-17T13:14:50Z