Is there a way to check what format they are in Qlik Sense?
When I inspect the field in the data model viewer it says $date on both fields if I load the separately. And the sample data showing is in 'YYYY-MM-DD'.
From the load script
This how the date_key is generated in the Calendar function
Date($(startDate) + IterNo() - 1) as date_key
And the QVD is loaded from a SQL Database with this date format 'YYYY-MM-DD'
If I load the QVD without the Exists I can select on fields of the Calendar, so the fields seem to join fine.
I will report this to the support on Monday.
I'm using 2.1 and also noted a different behavior between desktop and server whith the EXISTS clause. In some cases the workaround for this problem was use the LEFT KEEP prefix, so removing the records after load.
Could not have time to stop and figure out what is going on but your issue show me a clue, to create a test case and open a support case.