Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

filter pane with name months

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).

Tags (1)
2 Replies
Not applicable

Re: filter pane with name months

In script:

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

Not applicable

Re: filter pane with name months

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.