Chart with Multiple Calendars

Quamie — Sat, 16 Nov 2024 03:26:36 GMT

Hi All,

Thank you for taking a look!

I'm looking for some assistance in a way to combine data from 2 master calendars into a single chart.

I've been unable to make any progress on it. 😞

Here is the tree;

Here is the first chart;

Dimension: MonthYear

Count({$<MonthEnd_Flag={"1"}>}Distinct([Person Number]))

Second Chart

Dimension: ReqMonthYear

Sum({$<ReqMonthEnd_Flag={"1"}>}[# Openings])

Any idea on how I could total both charts in a single chart? E.g. May 2019 should be 3183+309 = 3492

I would highly prefer not to remodel the data, as it is currently modeled to take advantage of the Hierarchy Functions. Trying to write the expressions for those was pretty tough in the first place. 😞

Thank you for any advice!

Re: Chart with Multiple Calendars

Quamie — Tue, 28 May 2019 23:05:46 GMT

As usual some time away from the problem has allowed me to develop a solution.

I don't think this solution is a "clean" one, but it works. 😋

I simply duplicated the OpenReqs table, renamed all the fields and connected it to the original Master calendar, avoiding data loops by removing the other connections.

If anyone has a better suggestion, let me know!

topic Chart with Multiple Calendars in QlikView

Chart with Multiple Calendars

Re: Chart with Multiple Calendars