Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Have a look at this blog post Canonical Date by HIC.
His blog posts are always well worth reading.
Thank you! That looks like what I need.
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
Excellent reading for rainy afternoon.