Calendar problem

[gino2780]

Hello,

i've got a problem with the qlik sense calendar functioning.

You can see the calendar script load command script in the screenshots.

The data model shows that both tables are connected through the key %Datum.

When i try to select a date filter of the calendar in the qlik sheet the two KPIs, other filters from the loading list like LG Typ and Status as well as the table don't show anything. Any ideas on how to fix it?

[marcus_sommer]

Maybe your date isn't a date else a string which needs to be converted with a date#(Erstellt, 'YourFormatCode') function or it might be timestamp which needs to be cut off from the time part with: date(floor(Erstellt)).

- Marcus

[#3]

Why you taking two fields Datnum ..why you use use one Datenum?

Pls tell about that...