a common date for two unconnected table A and B

[Anonymous]

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

[dplr-rn]

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

Canonical Date

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