Dealing with 2 Calendars

prees959 — Thu, 08 Feb 2018 20:10:59 GMT

Hi,

I have a qvw that has two datasets each with its own unique calendar.

I have [arrivals_dataset] with an a[rrivals_master_calendar] and a [departures_dataset] with a [departures_master_calendar].

Within the arrivals_dataset I have :

Guest_ID (Key)

Arrival_ID (Key)

Arrival_Date

and other fields

Within the departures_dataset I have :

Guest_ID (Key)

Departure_ID (Key)

Departure_Date

and other fields

Is there any way to create a simple bar chart with a neutral 'Month Year' along the x-axis and show, per month, the total arrivals and total departures. We are trying to capture peak times as we can see that duration of stays vary wildly! I could achieve this in two separate charts based on each independent calendar - but it would be great if we could combine the two.

Any help appreciated!

Phil

Re: Dealing with 2 Calendars

neelamsaroha157 — Thu, 08 Feb 2018 20:18:50 GMT

You can achieve this by using a link table and creating a master calendar. In the link table you can have a field with your date_type as Arrival & Departure and use these in your expressions.

Something similar to this

topic Re: Dealing with 2 Calendars in QlikView

Dealing with 2 Calendars

Re: Dealing with 2 Calendars