Master calendar creates a loop in the data model

[morenoju]

Hi folks,

After loading data from several spreadsheets I've ended up with the following data model:

Users are expected to select an intersectionName but also a date and a time, so I tried to add a single Master Calendar in the load script. However, this is creating a loop:

I can't seem to find a way to break the loops. What would you recommend me to do in order to have a single master calendar but without ending up with a loop?

Thanks

[rwunderlich · Accepted solution]

You will want to gather your dates in a link table. For an example see

Qlikview Cookbook: Tutorial - Using Common Date Dimensions https://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/

-Rob

[morenoju]

Thanks Rob. Your tutorial was really helpful.