topic Re: Canonical Date in QlikView https://community.qlik.com/t5/QlikView/Canonical-Date/m-p/5775#M791517 <HTML><HEAD></HEAD><BODY><P>Yes, I did and that's what this data model is based on, I created three different calendars - Budget, Charges and Prod_Adj Calendar.</P></BODY></HTML> Tue, 23 Jan 2018 18:11:37 GMT Anonymous 2018-01-23T18:11:37Z Canonical Date https://community.qlik.com/t5/QlikView/Canonical-Date/m-p/5773#M791515 <HTML><HEAD></HEAD><BODY><P>I am working on an app where I have three different dates - Charges_Dt, Budget_Dt and Adj_Dt which need to be combined into one 'canonical date'. Also, the Prod_Adj table must be linked to the ChargesWRVU table. I tried doing that with this data model (attached), but it doesn't seem to be working. Any help or ideas would be appreciated. Thanks!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Canonical-Date/m-p/5773#M791515 Anonymous 2020-11-25T16:16:04Z Re: Canonical Date https://community.qlik.com/t5/QlikView/Canonical-Date/m-p/5774#M791516 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>have u tried to use multiple master calendar option ? this method should work for your case.</P><P>check this article</P><P><A href="https://community.qlik.com/qlik-blogpost/3585">Canonical Date</A></P></BODY></HTML> Tue, 23 Jan 2018 18:06:46 GMT https://community.qlik.com/t5/QlikView/Canonical-Date/m-p/5774#M791516 devarasu07 2018-01-23T18:06:46Z Re: Canonical Date https://community.qlik.com/t5/QlikView/Canonical-Date/m-p/5775#M791517 <HTML><HEAD></HEAD><BODY><P>Yes, I did and that's what this data model is based on, I created three different calendars - Budget, Charges and Prod_Adj Calendar.</P></BODY></HTML> Tue, 23 Jan 2018 18:11:37 GMT https://community.qlik.com/t5/QlikView/Canonical-Date/m-p/5775#M791517 Anonymous 2018-01-23T18:11:37Z Re: Canonical Date https://community.qlik.com/t5/QlikView/Canonical-Date/m-p/5776#M791518 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>can you share your mock app? may be u can take a look on the attached app as welll (they have used multiple calendar method)</P></BODY></HTML> Tue, 23 Jan 2018 18:31:35 GMT https://community.qlik.com/t5/QlikView/Canonical-Date/m-p/5776#M791518 devarasu07 2018-01-23T18:31:35Z