Qlik Community

Qlik Sense App Development

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

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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