Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

josecanalla
New Contributor III

Question about MasterCalendar

Hello, I have a big model with a large number of table loaded from databases. I create a Master Calendar, so all the Date fields of the different tables are linked with that.

I illustrate my problem with an example:

Table A:

DateColX
01/01/2017DataA
02/01/2017DataB
......

Table B:

DateColY
01/01/2017DataC
02/01/2017DataD

The two tables are not linked together, only are linked by the master calendar.


So if I select "DataA" from table A, it filter all rows of table B where the date != '01/01/2017' and I don't want this. I want to show entire table B data. Of course, if I don't use the Master Calendar I solve the problem but I want to use Master Calendar.

What can I do? Thanks!

Tags (1)
1 Reply

Re: Question about MasterCalendar

Maybe you need 2 Master Calendars or even a canonical date.

Have a look at this blog post by HIC Canonical Date