If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I need help to get my calendar to work properly. I have linked 3 different excel tabs on a ID and the datasources does all have dates (year) in it. The date is only for whole years.
When I link the three data sources on ID, and use a master calendar for filtering on years, two of the data sources does not respond. The charts with these data also give wrong numbers.
I have attached a test-app illustrating the problem.
You will need to create a link table in this case and then connect it to Master Calendar.
Please check below link, to understand how we could do it
View solution in original post
In your charts, you are using year-fields from your tables.
If selecting year from your mastercalendar you only get values from table 1 because this table is linked to your master calender.
Then from the other tables, you get values from theses ID where the date is in the selected year.
Reorganise your data model.
the create master calnendar