Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
helge_jorg
Creator
Creator

Master Calendar - data not responding

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

Labels (1)
1 Solution

Accepted Solutions
anushree1
Specialist II
Specialist II

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...

 

View solution in original post

2 Replies
martinpohl
Partner
Partner

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
Specialist II
Specialist II

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...

 

View solution in original post