topic Re: Multipule date related fields in same table in QlikView

Multipule date related fields in same table

pavan3334 — Sat, 16 Nov 2024 03:09:23 GMT

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.

Re: Multipule date related fields in same table

dplr-rn — Thu, 27 Jun 2019 20:46:45 GMT

You need canonical date concept

check below

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

Re: Multipule date related fields in same table

Brett_Bleess — Mon, 29 Jul 2019 21:28:22 GMT

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