Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gino2780
Contributor

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

Re: Calendar problem

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

Re: Calendar problem

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

Pls tell about that...

Community Browser