topic Prevent autocalendar within in auto-generate script in QlikView

Prevent autocalendar within in auto-generate script

Wed, 25 Nov 2020 16:16:04 GMT

Is there a way to keep the auto-generated section, but not have it include the creation of the autocalendar logic?

My understanding is that once you "unlock" the auto-generated script you can no longer use data manager to maintain tables and associations. However, I want to use data manager to manage tables, but I need to customize the autocalendar.

I added a section in script editor to "drop table autocalendar" then add my own autocalendar definition. However, this results in

The error occurred here: DROP TABLES statement.

Data has not been loaded. Please correct the error and try loading again.

If I add a autocalendar1 instead, I get doubled up feilds like "autocalendar.Year" and "autocalendar1.Year"

Re: Prevent autocalendar within in auto-generate script

swuehl — Tue, 13 Sep 2016 16:07:17 GMT

Have you tried to change the field type of your date field in data manager to something different than 'Date' type?

Re: Prevent autocalendar within in auto-generate script

Tue, 13 Sep 2016 17:41:46 GMT

Are you suggesting that I edit the fields that are being derived to not be date, then the auto calendar wont be created...thus I can just make make own calendar in script?

If that is right....I just tried and In data manager I am unable to adjust the type. see screen shot for what I see. Other fields in the table give a drop down with field type values of "general", "timestamp", "date".

My immediate need, but I was asking more generically, that I need a "hour" field for the autocalendar i.e. "Hour($1) AS [Hour] Tagged ('$axis', '$date', '$qualified');" but since I can't edit the autogenerated section, I thought if I could not have table made and then I do it in script that would solve it.

Re: Prevent autocalendar within in auto-generate script

Digvijay_Singh — Tue, 13 Sep 2016 19:36:01 GMT

You may try creating calculated field using 'Add field/Calculated field' in data manager. It appears true that once you unlock the script, data manager becomes almost mute.