Calendar related to 2 files

[ElenaDominguez]

Hello,

I have a fact table wich show the IT´s service orders and it has 2 date fields: created date and solution date.

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?

Thanks

[hic · Accepted solution]

Use a canonical date.

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

HIC

[ElenaDominguez]

Thank u very much!! The post is useful