Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
gino2780
Creator
Creator

Calendar problem

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?

Calendar_Script.JPG

Load Pipeline.JPG

Datenmodell.JPGArbeitsblatt.JPG

2 Replies
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

Not applicable

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

Pls tell about that...