Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
richters
Partner - Contributor III
Partner - Contributor III

Multiple Calender Tables link between years

Hi,

I'm a bit frustrated because of my problem.

I am handling different kinds of visits so there are a lot of date-fields in my application. Because I have different management ratios I need to have a calender-table for each of the fields. If I have just one master-calender (and I had it...) some of the ratios are summed up twice (new year = 2 years and double counting) so I decided to split the calenders.

My problem is now that I want to select a year and show all the values. Now that I have more than one year-field I don't know how to do that because when I select the start-year, the endyears are not possible values any more.

Anyone has got an idea how to deal with it?

Thanks a lot!

1 Reply
richters
Partner - Contributor III
Partner - Contributor III
Author

Got my own solution.

I added a hole Calender to the linkage table of all dates. Now I have got the structure :

all dates -> every kind of date

Now I can choose the year at all dates and can show the different kind of things in the other tables.