Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Rebel
Contributor II
Contributor II

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.

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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

View solution in original post

1 Reply
Gysbert_Wassenaar

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