Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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).
In script:
=month(MakeDate(2016,yourNumericMonthField)) as MonthName
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.