Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Master Calendar

Hi

my table has multiple rows for each date.

and when I use the master calendar codes and when the tables are automatically connected by [Complete Date], not all of the rows are picking up the Master Calendar data. actually more rows are missing the fields from the Master Calendar. How do I fix this problem?

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Master Calendar

Have you checked that your dates are not in fact timestamps that may not match with your master calendar dates?

A timestamp can be formatted as date using Date(), but the underlying value is keeping the time.

Why don’t my dates work?

3 Replies
MVP
MVP

Re: Master Calendar

Have you checked that your dates are not in fact timestamps that may not match with your master calendar dates?

A timestamp can be formatted as date using Date(), but the underlying value is keeping the time.

Why don’t my dates work?

Not applicable

Re: Master Calendar

Thank you! I aligned the format of dates in my fact table and calendar table and it works now!

Thanks!

MVP
MVP

Re: Master Calendar

David - I would advise you to close this thread by marking Stefan's response as the correct answer.