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
