Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
cbushey1
Creator III
Creator III

Link table and Master Calendar

Hi all,

I have multiple data sources that dont all share common fields. I have created a link table to bring them all together and was planning to build a master calendar that links to it. I am running into trouble trying to get the data to filter correctly when you pick different dates.

Here is what I have

Link table:

Key_HospID*YearMonth

Key_LocationYearMonth

Key_LocationYearMonthDay

YearMonthDay

YearMonth

Since my master calendar isnt based on the data (fixed beginning and end date of today) I linked the master calendar on the YearMonthDay field.

Any suggestions for how I can link all my data so that it filters by dates the user picks?

0 Replies