topic filter pane with name months in App Development https://community.qlik.com/t5/App-Development/filter-pane-with-name-months/m-p/1172528#M21464 <HTML><HEAD></HEAD><BODY><P>I have loaded a csv table into qlik sense but the names of the months are integers (1, 2, ..., 12). I want to create a filter pane with the real names of the months (january, february, ...., december). How can I do that? </P><P></P><P>Obviously I want to create the filter pane with the months in the real temporal order (not alphabetical or other orders).</P></BODY></HTML> Thu, 08 Sep 2016 21:59:37 GMT 2016-09-08T21:59:37Z filter pane with name months https://community.qlik.com/t5/App-Development/filter-pane-with-name-months/m-p/1172528#M21464 <HTML><HEAD></HEAD><BODY><P>I have loaded a csv table into qlik sense but the names of the months are integers (1, 2, ..., 12). I want to create a filter pane with the real names of the months (january, february, ...., december). How can I do that? </P><P></P><P>Obviously I want to create the filter pane with the months in the real temporal order (not alphabetical or other orders).</P></BODY></HTML> Thu, 08 Sep 2016 21:59:37 GMT https://community.qlik.com/t5/App-Development/filter-pane-with-name-months/m-p/1172528#M21464 2016-09-08T21:59:37Z Re: filter pane with name months https://community.qlik.com/t5/App-Development/filter-pane-with-name-months/m-p/1172529#M21465 <HTML><HEAD></HEAD><BODY><P>In script:</P><P>=month(MakeDate(2016,yourNumericMonthField)) as MonthName</P></BODY></HTML> Fri, 09 Sep 2016 00:48:44 GMT https://community.qlik.com/t5/App-Development/filter-pane-with-name-months/m-p/1172529#M21465 robert_mika 2016-09-09T00:48:44Z Re: filter pane with name months https://community.qlik.com/t5/App-Development/filter-pane-with-name-months/m-p/1172530#M21466 <HTML><HEAD></HEAD><BODY><P>Hi Michele,</P><P></P><P>You can try this,</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">suppose your date field name is <STRONG>Date_Field</STRONG></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">then =date(date#(month(monthstart(Date_Feild)),'MMM'),'MMMMM') </SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG><BR /></STRONG></SPAN></P><P>Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P></BODY></HTML> Fri, 09 Sep 2016 09:14:51 GMT https://community.qlik.com/t5/App-Development/filter-pane-with-name-months/m-p/1172530#M21466 2016-09-09T09:14:51Z