Multiple Calender Tables link between years

richters — Mon, 27 Aug 2012 09:10:22 GMT

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!

Re: Multiple Calender Tables link between years

richters — Mon, 27 Aug 2012 09:46:37 GMT

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.

topic Multiple Calender Tables link between years in QlikView

Multiple Calender Tables link between years

Re: Multiple Calender Tables link between years