Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using Common Calendar for multiple table

Hi,

Below is a screenshot of the data model with the common calendar I created. However I'm not able to use the dates in the ocmmon calendar as filters for my charts. Can anyone suggest me where I'm going wrong here?
Thanks

2 Replies
Gysbert_Wassenaar

I don't see what your common date has to do with hotel names. Those aren't dates. You need to get the dates from the different tables into the link table and replace them in those tables with a date key. Perhaps this document helps: Linking to two or more dates


talk is cheap, supply exceeds demand
Not applicable
Author

Hi Gysbert,

The document link you shared links all the dates in tables using OrderID I guess. The four tables in my data doesn't have such a unique ID common to all tables. Any suggestions how to link them?

I'm sorry, I'm new to Qlik Sense hence don't know much about data modelling. I'd really appreciate any help.

Thanks.