Master Calendar - data not responding

[helge_jorg]

Qlik experts

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.

Cheers

[martinpohl]

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.

Fatcs:

load

ID,

Dato,

Value1 

from Source1;

concatenate load

ID,

Dato,

Value2

from source2;

concatenate 

load

ID,

Dato,

Value3

from source3

;

the create master calnendar

Regards

[anushree1 · Accepted solution]

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

 https://community.qlik.com/t5/QlikView-App-Development/Tutorial-Using-Common-Date-Dimensions-and-Sha...