Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Creating Date

Good Day All~

I just want to ask how can I come up with a date with my data as 'January 2011, January 2012, February 2011, and so on.

I want to get the Month name and Year of the dates I have mentioned.

Thanks in advance,


4 Replies
Not applicable

Re: Creating Date

You can use


it will give you like Jan 2011, Feb 2012 ....

Valued Contributor

Re: Creating Date



Monthname(field name)&' '&Year(field name) as Monthname&Year

Honored Contributor II

Re: Creating Date

Please share your sample data

Valued Contributor II

Re: Creating Date

Set your monthnames in script as like

SET MonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

Use expression as Month(datefield)&' '&Year(datefield)

Community Browser