MasterCalender does not show values

[flowerPowerShower]

Hello qlik community, 

I have some problems associating my master calendar with my orders table. 

OrderDate comes from my Orders-table. 
Year and Day comes from my master calendar i wish to apply. 

However as you can see to every date my mastercalendar is applied the orderID is null. And the row below which doesnt contain the mastercalender holds the correct values. 

The MasterCalendar and the Order table is associated on OrderDate. 

[marcus_sommer · Accepted solution]

The format and/or values doesn't match between your tables. Your OrderDate is right-oriented and is therefore probably a numeric value but it may not be a date else a timestamp and then the values won't match. In this case you would need something like: date(floor(OrderDate)).

- Marcus

[flowerPowerShower]

Thanks it was actually that easy 🙂