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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
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 (3)
1 Solution

Accepted Solutions
BrunPierre
Partner - Master II
Partner - Master II

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 II
Partner - Master II

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!