Date filter for multiple tables

[Anonymous]

Hi,

I am new to Qlik Sense and have been given a project to work on, but having difficulty adding a date filter for tables. The 3 tables I have are all using different date columns but I would like to have ONE date filter, is this possible?

FILTER: StartDate and EndDate

Table 1:

MonthYear (StockDate)	Pieces Remaining
Jan2018	166
Feb2018	168
Mar2018	180
Apr2018	198

Table 2:

MonthYear (CreatedDate)	Pieces In
Jan2018	33
Feb2018	29
Mar2018	26
Apr2018	39

Table 3:

MonthYear (OrderDate)	Pieces Out
Jan2018	16
Feb2018	8
Mar2018	5
Apr2018	15

If this is not possible how do I just set the dates to the previous monthyear? Is that done in the expression for 'MonthYear'?

I managed to export the qvf file if this is useful?

Thank you in advance for your help.

[sunny_talwar]

Check this out

Canonical Date

[PrashantSangle]

is all date field coming from same table or 3 different tables??

You can create island calendar table to solve your issue.

Regards

[Anonymous]

Hi Prashant,

Dates are coming from 3 different tables.

[PrashantSangle]

Create Link table

try below logic

Table1:

Load key1,

         Date1,

          ...

From table1;

Table2:

Load Key2,

         Date2,

          ...

from Table2;

Table3:

Load Key3,

         Date3,

          ...

from Table3;

link_table:

Load key1,

         Date1 as Date

From table1;

Concatenate

Load Key2,

         Date2 as Date

from Table2;

Concatenate

Load Key3,

         Date3 as Date

from Table3;

Then create master calendar using date available in link_table

Regards,

Prashant Sangle