Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Dual(Date(Monthstart([TempDate]), 'YY MMM'), TempDate) as YearMonth
or
Dual(Date(Monthstart([TempDate]), 'YY MMM'), MonthStart(TempDate)) as YearMonth
Dual(Date(Monthstart([TempDate]), 'YY MMM'), TempDate) as YearMonth
or
Dual(Date(Monthstart([TempDate]), 'YY MMM'), MonthStart(TempDate)) as YearMonth
Hi Massimo
Thank you after using Dual , My chart look better in QS.
Before that it look like this , i don't like.