Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

Look at Canonical Calendar -> Canonical Date

View solution in original post

2 Replies
sunny_talwar

Look at Canonical Calendar -> Canonical Date

Not applicable
Author

Thanks for the reply sunny.