Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks Rob. Your tutorial was really helpful.