Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello dear all,
I am a new user of Qlik senser, I am wondering how can I create a common date for two unconnected table A and B. There is not a key to connect the table A and table B. But table A and Table B have a date field: date1 and date2 respectively. I am creating a date selection box containing year and month. The function i want to achive is table A and table b could share this same date selection box.
any tipps and suggestion will be pretty appreciated!
best regards,
Lucy
From my understanding of your requirement you have 2 date fields which you want to use as part of a single date filter
if thats correct
best approach would be canonical date.See below
its also possible to create a separate island calendar and use that for selection and use set analysis to filter but not recommended for performance reasons