Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

master calendar only row 1 have year month the rest missing value

Hi All

I have create a master calendar using the below script :-

MasterCalendar:

LOAD TempDate AS date_time,

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

  MY AS MonthYear,

    D     AS Day,

    M     AS Month,

  Y AS year

RESIDENT TempCalendar

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 ?

Paul

1 Solution

Accepted Solutions
rubenmarin

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

View solution in original post

3 Replies
rubenmarin

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

fernando_tonial
Partner - Specialist
Partner - Specialist

You have use only field date format or number, without time.

Best Regards.

Tonial.

Don't Worry, be Qlik.
paulyeo11
Master
Master
Author

Hi Ruben

Now working fine , after i convert field which have date and time into month and year , now working fine.

Paul