topic Re: Master Calendar with 3 IDs/3 Calendars in QlikView

Master Calendar with 3 IDs/3 Calendars

Mon, 13 Apr 2015 17:20:26 GMT

Hi everyone,

I am posting a sample QVW - I have 3 ID/Year/Amounts that I want to link together with a master Year field, but still have the option to select one of the specific year fields as well. Does anyone know how I can do this?

Re: Master Calendar with 3 IDs/3 Calendars

rwunderlich — Mon, 13 Apr 2015 19:36:57 GMT

‌See if this example fits your case.

Qlikview Cookbook: Tutorial - Using Common Date Dimensions http://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/

ROb

Re: Master Calendar with 3 IDs/3 Calendars

Mon, 13 Apr 2015 19:40:35 GMT

Hi Rob,

Thanks for your response. I tried your solution before but, while I loved how well it was presented, I could not implement it. I think this is because I have 3 different IDs, not just OrderID as in your tutorial.

Re: Master Calendar with 3 IDs/3 Calendars

prieper — Mon, 13 Apr 2015 19:55:12 GMT

Why would you do so? The years in these tables does not have much in common, but a field related to a year. What will be the benefit to have a year to select?

Nevertheless you may concatenate the datatables and always add a field "Year", like

Load *, EventYear AS Year INLINE [

HTH Peter

Re: Master Calendar with 3 IDs/3 Calendars

Tue, 14 Apr 2015 15:57:56 GMT

Hi Peter,

Thanks for your reply. I tried your solution, and it works as intended. However, it is not the ideal solution because I also want to show how the data is related across the three year fields.

Here is my example. In the app I attached, you can see that in EventYear 2012, there are two EventIDs, 2 & 3. Those two EventIDs are associated with 4 PersonnelIDs, a - b - c - d. Finally, you can see that a - b - c - d have PersonnelAmounts that go from 2008-2012 in the PersonnelYear field.

So ideally, I want

1) to be able to click '2012' in EventYear and get all associated amounts for all personnel in all PersonnelYears for that event, and

2) I want a common Year field where if I select 2008-2012, I only get Amounts and IDs within that time range.

Re: Master Calendar with 3 IDs/3 Calendars

prieper — Tue, 14 Apr 2015 21:07:24 GMT

Hi Andrew,

then you should create a separate table with all possible combinations: year and IDs and link back the data.

Peter