Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

Using one auto calender for multiple data sets

Dear all, 

I am using an auto calendar in my Qlik sense code. The calendar transforms data from different data sets (lets say data_set1, data_set2, data_set3). Each data set has a  column with a date ( date1, date2, date 3). Yet, in the front end I can only implement and use the calendars separately. They are displayed as:  "autocalenderdate1",  "autocalenderdate2",  "autocalenderdate3". Yet, I would like to display data from different data sources in one chart, with date on the x-achsis. Hence, I would need one uniform calendar/date dimension. 

The code is as follows:

[autoCalendar]:
DECLARE FIELD DEFINITION Tagged ('$date')
FIELDS
Dual(Year($1), YearStart($1)) AS [Year] Tagged ('$axis', '$year'),

(...)

DERIVE FIELDS FROM FIELDS
[date1],
[date2],
[date3],
USING [autoCalendar] ; 

 

I am thankful for any hint or advice!

Best

Anna

Labels (6)
0 Replies