topic Re: Multiple Master Calendars in QlikView

Multiple Master Calendars

jp_afc — Thu, 29 Jun 2023 13:19:08 GMT

I have 2 dates fields Reported Date and Incident date. I have created 2 master calendars one for each of the date fields. I want to create a table to see how many incidents occurred based on 'Incident date' and have a filter pane using reported date. So when I filter using the reported date I want to see how many incidents occurred on that date.

For example, On Reported Date 02/01/21 there were 0 incidents reported but on that same day 5 incidents occurred. So when i click on the filter pane '02/01/21' (which is based on reported date) I want the table to show 5 incidents occurring on the date of 02/01/21.

I don't have this issue if there was an incident that was reported on a certain date. e.g if on 06/02/2023 there were 3 reported incidents and on the same date 5 incidents occurred, on my table for the date 06/02/2023 it would show 4.

I hope this make sense

Re: Multiple Master Calendars

rwunderlich — Thu, 29 Jun 2023 13:26:02 GMT

I typically approach this using a common Master Calendar for multiple date fields. You can download a working example in QlikView or Qlik Sense from here https://qlikviewcookbook.com/list-recipes/#squelch-taas-accordion-shortcode-content-18.

-Rob

Re: Multiple Master Calendars

Rachel45 — Tue, 04 Jul 2023 04:10:10 GMT

You can create a table to see how many incidents occurred based on the Incident Date and filter the table by the Reported Date. To do this, you can create a calculated field in the Incident Date column that calculates the number of incidents that occurred on that date. marykayintouch