Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
FabioMartinelli
Contributor
Contributor

section access (section application) doesn't work

hi,
i have a problem with the section access.

After the reload the section application doesn't apply any data restition. 
Users should see a set of "Company Code" but they see all companies.
the section access works: only the users in the file can access.
the section application doesn't work: all user can see all data.
 
where is the error?

This is the script that i  wrote:

 

Section Access;

Security:
LOAD NAME,
SERIAL,
Upper(NTNAME) as NTNAME,
USER.EMAIL,
Upper(ACCESS) as ACCESS,
[DATAREDUCTION<GROUP1>]

FROM [lib://MYFILE.xlsx]
(ooxml, embedded labels, table is SECURITY);


Section Application;

SECLINK_SecurityLevel:
LOAD
[DATAREDUCTION<GROUP1>],
Company_Code as TR_Company_Code
FROM [lib://MYFILE.xlsx]
(ooxml, embedded labels, table is GROUP1);

 

 

in attach section access file.

Labels (2)
1 Solution

Accepted Solutions
BrunPierre
Partner - Master
Partner - Master

Hi, When loading data from an external source in the SECTION ACCESS statement, it is mandatory for ALL the data to be in uppercase.

View solution in original post

2 Replies
BrunPierre
Partner - Master
Partner - Master

Hi, When loading data from an external source in the SECTION ACCESS statement, it is mandatory for ALL the data to be in uppercase.

FabioMartinelli
Contributor
Contributor
Author

Thanks for the help. Works!

great!