Using one auto calender for multiple data sets

Anna12 — Sat, 16 Nov 2024 17:58:18 GMT

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

topic Using one auto calender for multiple data sets in App Development

Using one auto calender for multiple data sets