Multiple join table

[Anonymous]

Hi

I'm currently having an issue where I need to link my Date table to multiple fields in my fact table InternetSales.

The fields are DueDateKey, OrderDateKey and ShipDateKey from Internet Sales and should be linked with DateKey from Date table but Qlik only allows me to join once. I've attached my project if its not very clear.

Thank you in advance

[Anonymous]

Have a look at this blog post Canonical Date by HIC.

His blog posts are always well worth reading.

[Anonymous]

Thank you! That looks like what I need.

[Anonymous]

Glad you are the road, if ever the weather is bad and you get bored then this link will list all of Henric's blog posts

Henric's Blog Posts

Excellent reading for rainy afternoon.