filter pane with name months

[#1]

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?

Obviously I want to create the filter pane with the months in the real temporal order (not alphabetical or other orders).

[robert_mika]

In script:

=month(MakeDate(2016,yourNumericMonthField)) as MonthName

[#3]

Hi Michele,

You can try this,

suppose your date field name is Date_Field

then =date(date#(month(monthstart(Date_Feild)),'MMM'),'MMMMM')

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.