This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have a source, where date is formatted in month and year columns:
I want to convert it to MM.YYYY format and use it as Time dimension in charts etc.
I already tried this function: DATE (MakeDate(MONTH('month'),YEAR('year')),'MM.YYYY') as date2,
but did not solve the problem. After load, new field date2 just shows '-'
Perhaps it is conflicted with my SET statements:
LOAD *, DATE(MakeDate(year,month),'MM.YYYY') AS MY_DATE,
LOAD * Inline
View solution in original post
Year is the first argument for the MAKEDATE function.
From QV Help:
MakeDate(YYYY [ , MM [ , DD ] ])
Return data type: dual
If no day is stated, 1 (the 1st) is assumed.
Thank you, MakeDate in the right order with Inline load worked perfectly!
Try changing your expression to Date(MonthEnd(makedate(2018,3)),'MM.YYYY')