Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist II
Specialist II

Re: Master Calendar - data not responding

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
Highlighted
Partner
Partner

Re: Master Calendar - data not responding

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

Highlighted
Specialist II
Specialist II

Re: Master Calendar - data not responding

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