topic Re: Why does Qlik Sense keep generating an Auto-generated section? in App Development

Why does Qlik Sense keep generating an Auto-generated section?

Markbhai — Fri, 17 May 2024 16:09:33 GMT

I am learning Qlik Sense and so as a result I tend to hop between Data Manager and Data Load Editor - I find Data Manage useful to help with adding fields etc when I am not clear on syntax.

What I do find though is that Qlik is creating an Auto Genrated Script and including things which appear to be working perfectly well. For example:

I have a country field in my load script and have included:

__countryAliasesBase:

LOAD

Alias AS [__Country],

ISO3Code AS [__ISO3Code]

FROM [lib://Live - ProvePrivacy:DataFiles/countryAliases.qvd]

(qvd);

__countryGeoBase:

LOAD

ISO3Code AS [__ISO3Code],

ISO2Code AS [__ISO2Code],

Polygon AS [__Polygon]

FROM [lib://Live - ProvePrivacy:DataFiles/countryGeo.qvd]

(qvd);

__countryName2IsoThree:

MAPPING LOAD

__Country,

__ISO3Code

RESIDENT __countryAliasesBase;

__countryCodeIsoThree2Polygon:

MAPPING LOAD

__ISO3Code,

__Polygon

RESIDENT __countryGeoBase;

As well as:

APPLYMAP( '__countryCodeIsoThree2Polygon', APPLYMAP( '__countryName2IsoThree', LOWER([overseas_country])), '-') AS [international_safegaurds.overseas_country_GeoInfo];

SELECT

id,

`international_safegaurds_description`,

`overseas_country`,

...

FROM `db`.`international_safegaurds`;

APPLYMAP( '__countryCodeIsoThree2Polygon', APPLYMAP( '__countryName2IsoThree', LOWER([overseas_country])), '-') AS [international_safegaurds.overseas_country_GeoInfo];

SELECT

id,

`international_safegaurds_description`,

`overseas_country`,

`overseas_privacy_sheild`,

`overseas_Safegaurd`,

`overseas_Safegaurd_Exception`,

`overseas_owner`,

// `overseas_expiry`,

`overseas_freequency`,

`overseas_volume`,

`overseas_compelling`,

`overseas_advised`,

file,

status,

`document_purpose`,

`document_location`

// `data_sharing_id`

FROM `prove_privacy`.`international_safegaurds`;

TAG FIELD [overseas_country] WITH '$geoname', '$relates_international_safegaurds.overseas_country_GeoInfo';

TAG FIELD [international_safegaurds.overseas_country_GeoInfo] WITH '$geopolygon', '$hidden', '$relates_overseas_country';

However if I open Data Manager the auto generated script is added and the country GeoInfo field is re added appended with a '_1' e.g.

TAG FIELD [international_safegaurds.overseas_country_GeoInfo_1] WITH '$geopolygon', '$hidden', '$relates_overseas_country';

Is there a reason why this keeps happening?

Very frustrating.

Re: Why does Qlik Sense keep generating an Auto-generated section?

igoralcantara — Sat, 18 May 2024 01:32:47 GMT

When you add tables to the Data Manager, click on the … button and disable to Data Profiling option to stop this behavior.

Re: Why does Qlik Sense keep generating an Auto-generated section?

Markbhai — Wed, 22 May 2024 07:30:53 GMT

Thank you. I have been using it this way for a day or so now and life feels much less stressful. 🙂

It has forced me into manually adjusting the load scripts rather than relying on the Data Manager, but I think I have learned enough over the last few weeks to stand on my own now.

Re: Why does Qlik Sense keep generating an Auto-generated section?

igoralcantara — Wed, 22 May 2024 08:19:30 GMT

Great!! I am happy to help.

Re: Why does Qlik Sense keep generating an Auto-generated section?

Kelliesy — Tue, 10 Sep 2024 20:38:03 GMT

If I'm using the load script to add the data I am running into the same issue. Is there a way to turn this off if I use the load script and not the "Add Data" option?

Re: Why does Qlik Sense keep generating an Auto-generated section?

Markbhai — Wed, 11 Sep 2024 07:29:17 GMT

Hi Kelliesy,

I could not find a way to turn it off, in the end I just stopped using the Data Manager (which is the part of Qlik that creates the Auto Generated section)) and just started to use the Load Editor only.