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] ;