topic How to change my YearMonth script start to Dual ? in QlikView

How to change my YearMonth script start to Dual ?

paulyeo11 — Sun, 06 Sep 2015 03:55:49 GMT

Hi All

I have a Load Script as below :-

Date(Monthstart([TempDate]), 'YY MMM')

as YearMonth,

I like to change the above using Dual , meaning some thing like :-

Dual(Date(Monthstart([TempDate]), 'YY MMM'))

as YearMonth,

As i encounter issue when i use YearMonth field in QS . it display as number instead of YearMonth like 2015 Jan.

Paul

maxgro — Sun, 06 Sep 2015 07:25:28 GMT

Dual(Date(Monthstart([TempDate]), 'YY MMM'), TempDate) as YearMonth

Dual(Date(Monthstart([TempDate]), 'YY MMM'), MonthStart(TempDate)) as YearMonth

paulyeo11 — Sun, 06 Sep 2015 07:42:43 GMT

Hi Massimo

Thank you after using Dual , My chart look better in QS.

Before that it look like this , i don't like.