How to stop a loop from being created

[Diere29]

Hey, I have this Qlik sense report that is creating loops.

• the user wants the report to be able to toggle by the date field dynamically. At the moment it doesn't do this. The date fields on the visual sheets are all separate fields so its not really intuitive 
• I have tried to connect the Date fields directly to one another and it created a loop
• I have tried to connect the date fields via a calendar dimension table and it also created a loop 

[Vegar · Accepted solution]

You would need some kind of canonical Date solution for this. Maybe by moving the date fields to the MASTER_SKU table and create a date link table from that table to a master calendar. Does the ids x_SKU associate with a single date?