I have many tables and each table contains a date field. I want to create one calendar but idon't know if it's possible with many dates. Is there a way to create measures and in the set analysis i refer to the exact date that i want? and should i create many calendares or just one which is disconnected from the model?
It is better to propose several mastercalendar than one (if the meaning of the dates is not the same) The proposal I gave above will cause a problem (maybe it's not your case), but with only one date linked to all the tables, for example in the mastercalendar I selected 16/12/2019 as the purchase date, Qlikview will also select all the dates with 16/12/2019 (sales date for example) which is not logical.