https://community.qlik.com/t5/QlikView/Calendar-related-to-2-files/m-p/1516900#M750342 <P>Hello,</P><P>I have a fact table wich show the IT´s service orders and it has 2 date fields: created date and solution date.</P><P>How can i make it so that within my application i can select a month and show me an indicator of how many orders were created and how many orders were closed?</P><P>Thanks</P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT ElenaDominguez 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Calendar-related-to-2-files/m-p/1516900#M750342 <P>Hello,</P><P>I have a fact table wich show the IT´s service orders and it has 2 date fields: created date and solution date.</P><P>How can i make it so that within my application i can select a month and show me an indicator of how many orders were created and how many orders were closed?</P><P>Thanks</P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Calendar-related-to-2-files/m-p/1516900#M750342 ElenaDominguez 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Calendar-related-to-2-files/m-p/1516907#M750343 <P>Use a canonical date.</P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578</A></P> <P>HIC</P> Wed, 05 Dec 2018 15:43:04 GMT https://community.qlik.com/t5/QlikView/Calendar-related-to-2-files/m-p/1516907#M750343 hic 2018-12-05T15:43:04Z https://community.qlik.com/t5/QlikView/Calendar-related-to-2-files/m-p/1517621#M750344 Thank u very much!! The post is useful Thu, 06 Dec 2018 20:10:52 GMT https://community.qlik.com/t5/QlikView/Calendar-related-to-2-files/m-p/1517621#M750344 ElenaDominguez 2018-12-06T20:10:52Z