Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Not applicable

Master calendar using two dates in two tables?

Hi all,

Table1:

Material    PaidDate    PaidAmount     BU    customer

Table2:

Supplier   SpendDate      SpendAmount  

Table3:

Material    Supplier


I have these three tables to use.

I have to make association between two these tables based on Date in first 2 tables and then with third table.

The problem I am facing here is how to use the two date columns (PaidDate and SpendDate) in master calendar .

(Spend is in one month and paid is in different month)

How can I achieve this ?


Thanks and regards

Prashanth.

1 Solution

Accepted Solutions

Re: Master calendar using two dates in two tables?

Look at Canonical Calendar -> Canonical Date

2 Replies

Re: Master calendar using two dates in two tables?

Look at Canonical Calendar -> Canonical Date

Not applicable

Re: Master calendar using two dates in two tables?

Thanks for the reply sunny.

Community Browser