topic Use different Date dimension in Management & Governance https://community.qlik.com/t5/Management-Governance/Use-different-Date-dimension/m-p/1803005#M19311 <P>Hello Everybody. I having issues to provide a simple needs and maybe I'm doing something wrong.</P><P>I have a table of the order with 2 dates: Date Of Order and Date Of Delivery.</P><TABLE border="1"><TBODY><TR><TD>DATE OF ORDER</TD><TD>DATE OF DELIVERY</TD><TD>ORDER ID</TD></TR><TR><TD>1/1/2021</TD><TD>2/1/2021</TD><TD>A</TD></TR><TR><TD>1/1/2021</TD><TD>2/1/2021</TD><TD>B</TD></TR><TR><TD>2/1/2021</TD><TD>3/1/2021</TD><TD>C</TD></TR><TR><TD>2/1/2021</TD><TD>3/1/2021</TD><TD>D</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I would like to have a chart like this:</P><TABLE border="1"><TBODY><TR><TD>DATE</TD><TD>NUMER OF ORDER</TD><TD>NUMBER OF DELIVERY</TD></TR><TR><TD>1/1/2021</TD><TD>2</TD><TD>0</TD></TR><TR><TD>2/1/2021</TD><TD>2</TD><TD>2</TD></TR><TR><TD>3/1/2021</TD><TD>0</TD><TD>2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Can you please kindly give me an idea how to solve easly?</P><P>Thank you very much for any help.</P> Tue, 27 Apr 2021 08:51:25 GMT Boseca 2021-04-27T08:51:25Z Use different Date dimension https://community.qlik.com/t5/Management-Governance/Use-different-Date-dimension/m-p/1803005#M19311 <P>Hello Everybody. I having issues to provide a simple needs and maybe I'm doing something wrong.</P><P>I have a table of the order with 2 dates: Date Of Order and Date Of Delivery.</P><TABLE border="1"><TBODY><TR><TD>DATE OF ORDER</TD><TD>DATE OF DELIVERY</TD><TD>ORDER ID</TD></TR><TR><TD>1/1/2021</TD><TD>2/1/2021</TD><TD>A</TD></TR><TR><TD>1/1/2021</TD><TD>2/1/2021</TD><TD>B</TD></TR><TR><TD>2/1/2021</TD><TD>3/1/2021</TD><TD>C</TD></TR><TR><TD>2/1/2021</TD><TD>3/1/2021</TD><TD>D</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I would like to have a chart like this:</P><TABLE border="1"><TBODY><TR><TD>DATE</TD><TD>NUMER OF ORDER</TD><TD>NUMBER OF DELIVERY</TD></TR><TR><TD>1/1/2021</TD><TD>2</TD><TD>0</TD></TR><TR><TD>2/1/2021</TD><TD>2</TD><TD>2</TD></TR><TR><TD>3/1/2021</TD><TD>0</TD><TD>2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Can you please kindly give me an idea how to solve easly?</P><P>Thank you very much for any help.</P> Tue, 27 Apr 2021 08:51:25 GMT https://community.qlik.com/t5/Management-Governance/Use-different-Date-dimension/m-p/1803005#M19311 Boseca 2021-04-27T08:51:25Z Re: Use different Date dimension https://community.qlik.com/t5/Management-Governance/Use-different-Date-dimension/m-p/1803079#M19312 <P>Hi,&nbsp;</P><P>Please find attached QVF with an example based on your data.&nbsp;</P><P>Idea is to create a link table in your script with a common date field.&nbsp;</P><P>Some interesting reading about this topic:&nbsp;</P><UL><UL><LI><A href="https://community.qlik.com/t5/QlikView-Documents/Linking-to-two-or-more-dates/ta-p/1495322" target="_self"><SPAN>Linking to two or more dates</SPAN></A></LI><LI><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578" target="_self"><SPAN>Canonical Date</SPAN></A></LI></UL></UL><P>&nbsp;</P><P><SPAN class="lia-message-unread lia-message-unread-windows"><SPAN>Hope this helps!</SPAN></SPAN></P> Tue, 27 Apr 2021 11:23:46 GMT https://community.qlik.com/t5/Management-Governance/Use-different-Date-dimension/m-p/1803079#M19312 Bastien_Laugiero 2021-04-27T11:23:46Z Re: Use different Date dimension https://community.qlik.com/t5/Management-Governance/Use-different-Date-dimension/m-p/1803479#M19323 <P>Thank you very much! It work like a charm.</P> Wed, 28 Apr 2021 11:35:21 GMT https://community.qlik.com/t5/Management-Governance/Use-different-Date-dimension/m-p/1803479#M19323 Boseca 2021-04-28T11:35:21Z