Discussion Board for collaboration on QlikView Scripting.
I have create a master calendar using the below script :-
LOAD TempDate AS date_time,
Date(Monthstart([TempDate]), 'YY MMM') as YearMonth,
MY AS MonthYear,
D AS Day,
M AS Month,
Y AS year
ORDER BY TempDate ASC;
DROP TABLE TempCalendar;
My issue is YearMonth field does not recode the date_time only the first row , and give the rest of the row missing value , where i make the mistake ?
Go to Solution.
Hi Paul, all your rows in master calendar has his YearMnoth field with value.
Problem is you are getting date and time in your date_time field, so master calendar only has values for each day at 3:28:23 PM, other "times" in the same date has no relation with master calendar.
So you need to link with master calendar only with date, no time, and it should work
You have use only field date format or number, without time.
Now working fine , after i convert field which have date and time into month and year , now working fine.