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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
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.