Discussion board where members can learn more about Qlik Sense Data Connectivity.
Material PaidDate PaidAmount BU customer
Supplier SpendDate SpendAmount
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
Go to Solution.
Look at Canonical Calendar -> Canonical Date
Thanks for the reply sunny.