Multiple Link

[Gabbar]

Hi all, I have to join my fact table to my Calendar dimension table,
Fact table contains both Order Date and Shipping Date, 
And in my UI I have to create KPI which uses either one of those or both.
Just how can I solve this issue because If I do MTD or YTD on bases on shipping date it should show different and on basis of Order date it should show different.
Please Guide.

[sidhiq91 · Accepted solution]

@Gabbar  I guess you might need to use the concept of Canonical Calendar concept. Please follow below link to get some idea on it.

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

https://community.qlik.com/t5/QlikView-App-Dev/Master-Calendar-Canonical-Calendar/m-p/1174607

Please let me know if this helped you out.

[Gabbar]

Thank you very much man, this sorts out my problem completely.

[sidhiq91]

@Gabbar  if it resolved your issue please like and accept it as a solution so that it helps other community members as well.