Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
gmenoutis
Partner - Creator II
Partner - Creator II

Section access reduction doesn't work

I have been trying to get section access reduction to work, with no avail.

In order to simplify my case, I have included only the following in my script:

Section Access;

LOAD *

Inline [

ACCESS,USERID,Brand Name

USER,my_user_directory\my_user_ID,A

];


section application;


data:

LOAD *

Inline [

Brand Name

A

B

C

D

];


I know my userid is correct, since changing one character in it makes the app give me "no access" error when I try to open it.

I also know the "Brand Name" field is the same, because if I replace the "section access" line with "table1:" (giving the section access table a name), then if I choose my username value on field USERID it indeed shows A as possible and B,C,D as excluded.


I am using version September 2017 enterprise.

1 Solution

Accepted Solutions
stigchel
Partner - Master
Partner - Master

All Fields and Fieldvalues of the section access must be in uppercase, so use e.g. BRANDNAME instead of [Brand Name]

View solution in original post

1 Reply
stigchel
Partner - Master
Partner - Master

All Fields and Fieldvalues of the section access must be in uppercase, so use e.g. BRANDNAME instead of [Brand Name]