date format in source

[Mahamed_Qlik]

Hi All,

I have "Month" field in my database which has values as below:

MonthNumber

07

06

05

04

When I use Month(MonthNumber) in qliksense, It is showing incorrect month name.

for example -
if I select 07 then it is showing month name as "Jan" not July.

Kindly help.

Regards,
Mahamed

[Mark_Little]

Hi @Mahamed_Qlik 

The first place i would check is on the main tab in the script editor.

Check that 

SET FirstMonthOfYear=1;

If this have been change you could get the result you are seeing

[Mahamed_Qlik]

Hi Mark,

It is set as you mentioned:

[justISO]

Hi, try something like this:

Month( Date(Date#(MonthNumber,'MM')) ) or

date(Date#(MonthNumber,'MM'), 'MMM')  - 'MMM' here defines short month name, use 'MMMM' if you need long one