Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rsingh43
Contributor

Date filter for multiple tables

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
Jan2018166
Feb2018168
Mar2018180
Apr2018198

Table 2:

MonthYear (CreatedDate)Pieces In
Jan201833
Feb201829
Mar201826
Apr201839

Table 3:

MonthYear (OrderDate)Pieces Out
Jan201816
Feb20188
Mar20185
Apr201815

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.

4 Replies
MVP
MVP

Re: Date filter for multiple tables

Check this out

Canonical Date

Re: Date filter for multiple tables

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

You can create island calendar table to solve your issue.

Regards

Regards,
Prashant Sangle
rsingh43
Contributor

Re: Date filter for multiple tables

Hi Prashant,

Dates are coming from 3 different tables.

Re: Date filter for multiple tables

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

Regards,
Prashant Sangle