Relationships: A & B are both on the same date, but A & B should not be related

[#1]

Amusement aside, how can I create the right table links so that I can have a table about A which is related to a date, and another table about B related to dates, but to not have A & B directly related to each other? I do want to keep the date field related so that I can have a slider for the time period.

Many thanks,

Isabel

[#2]

(This links to a far less ammusing post I made earlier which includes the mock-up Excel data and Qlivkiew model)

[jvitantonio]

If you don't want them to be joined, then you need to rename the fields with two different names (DateA and DateB).

Then you cna use a island table with dates that you can use in the slider.

I hope this helps.

[#4]

Thank you user14 - this sounds like a likely solution. Please may you explain what island tables are or direct me to an explanation?

Thanks

[Gysbert_Wassenaar · Accepted solution]

You can try a link table. See this discussion

[calvindk]

Be aware that:

the advantage of a data island calendar, is that it is isolated from your link.

the disadvantage is that you usually have to do expression work to reference, so your document becomes slower.

You could also make a shared calendar that has multiple same date fields.

something like this:

http://community.qlik.com/thread/48693

date,

date as dateA, //linking to A

date as dateB, //linking to B

month,

year

[jvitantonio]

Hi, Island tables are thouse that are not connected to the model and work independently.

In your case this table would be a calendar (or a table with the dates that you also have in tableA and tableB (DateA and DateB field values).

You then can use the date field of the island table in the slider and use set analysis to compare data for TableA and tableB using the variable in the slider.

[#8]

Hi Anders,

Thanks for this. Following the video link and the script, I have now set up two independent calanders that work fine. I am still unsure how I can link these calanders. Any further tips?

Isabel

[calvindk]

try only setting up one calendar, and then just have the date field replicated with different names. when you set up the master calendar, make sure the max and min applies to max of either datea or dateb.

also make sure to see the link gysbert mentioned below.

[#10]

Thanks Gysbert,

This link gave me the solution from Rob Wunderlich and it was simple to use too.

Thanks all for you suggestions,

Isabel