Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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

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;

2 Replies
thomaslg_wq
Contributor III

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

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

thomaslg_wq
Contributor III

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

You should look at this :

Basics for complex authorization

Very good post.