Multipule date related fields in same table

[pavan3334]

Hi Everyone , I am very new to qlik view(learning now), i need your help on below scenario,

i have a table, which is having  field names like below.

[Case initiated date]

[Case due date]

[Case closed date]

I want create common Month and Year fields by using list box, when I click on any month, I want get the data from all the  fields

Ex: if I click Jan – the result should be

How many cases initiated in JAN month, How many cases having due dates in JAN and how many cases closed in JAN.

[dplr-rn]

You need canonical date concept

check below

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

[Brett_Bleess]

Here is another Design Blog related to Master Calendar just in case the other is not what you needed:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527

You can back up the URL to the Qlik-Design-Blog level and then search the entire Design Blog as well, just FYI, hopefully that will let you dig around on your own.  Hope this helps a bit more if you are still working on things.

Regards,
Brett