Help with canonical date

[OmarBenSalem]

Hi all, 

I'm trying to implement the canonical date logic but with no success; I might need some help ! ( @sunny_talwar  , @hic , @rwunderlich  )

Here's what I have 2 AGGREGATED tables by OfferNumber (the filed is numero_offre) (can't change the way tables are)

1) Table 1 : Consultations:

I contains this : (so the Key is numero_offre)

how many has consulted the offer in each date..

the second table is : Postulations (same thing, the Key is numero_offre) : how many has applied for the offer in each date

What I did : I created a calendar for each table BUT couldn't find a way to create the BRIDGE TABLE as described here : 

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

Can anyone help PLEASE?

[OmarBenSalem]

ANYONE?

[rwunderlich]

Download this example to see if it answers your question: 

Qlikview Cookbook: Tutorial - Using Common Date Dimensions http://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com