topic Re: After Applying Section Access on Area Code, Territory Code and Region a few Region disappear? in QlikView

After Applying Section Access on Area Code, Territory Code and Region a few Region disappear?

Mon, 26 Jan 2026 18:19:17 GMT

After Applying Section Access on Area Code, Territory Code and Region but a few Regions disappear, after applying admin security overide in the document security it starts showing all the regions and everything . Unable to understand the issue.

Section Access;

LOAD ACCESS,

NTNAME,

REGION_KEY,

text(TERRITORY_KEY) as TERRITORY_KEY,

text(AREA_KEY) as AREA_KEY,

BRAND_KEY

FROM

(ooxml, embedded labels, table is Sheet1);

LOAD ACCESS,

REGION_KEY,

text(TERRITORY_KEY) as TERRITORY_KEY,

text(AREA_KEY) as AREA_KEY,

BRAND_KEY

FROM

(ooxml, embedded labels, table is Sheet2);

Section Application;

Re: After Applying Section Access on Area Code, Territory Code and Region a few Region disappear?

thomaslg_wq — Thu, 01 Dec 2016 16:01:43 GMT

Does the section access file contains all the possibilities ? It must be the issue. ==> Your second table should be created not with the section access source but with your model fact table.

And, you should work with only one field ==> REGION_KEY&'/'&TERRITORY_KEY&'/'&AREA_KEY&'/'&BRAND_KEY as %SECURITY_KEY

Re: After Applying Section Access on Area Code, Territory Code and Region a few Region disappear?

thomaslg_wq — Thu, 01 Dec 2016 16:03:29 GMT

You should look at this :

Basics for complex authorization

Very good post.