
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
AutoCalendar on a Calculated Field?
First time poster, so please be gentle.
Using Qlik Sense June 2018. I have a calculated field that compares the Dates in two source fields and returns the most recent Date. I want to create a visualization based on this calculated field using the autoCalendar functionality, but the autoCalendar is not applied to this field.
Is it possible to use the autoCalendar functionality on this calculated field? If so, how? (I hope this can be done in Data Manager, because I would rather not tinker with the load editor.)
Thanks.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I don't think you can do this with the Data Manager. But it's fairly easy to add. Open the Data Load editor and add a new section after the Autogenerated section. In that section add this line
DERIVE FIELDS FROM MyNewDateField USING autoCalendar;
Replace MyNewDateField with the name of the calculated field you created.
talk is cheap, supply exceeds demand

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I don't think you can do this with the Data Manager. But it's fairly easy to add. Open the Data Load editor and add a new section after the Autogenerated section. In that section add this line
DERIVE FIELDS FROM MyNewDateField USING autoCalendar;
Replace MyNewDateField with the name of the calculated field you created.
talk is cheap, supply exceeds demand
