Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wanyunyang
Contributor

section access not working

I'm adding a new user to two Dashboards section access, but only one works, I have no idea why.

In the succeeded Dashboard, my script is like:

section access;

LOAD * inline

[ACCESS, USERID,REDUCTION

......

USER, 807037-BI01\operationsuser, DIRECTOR

......

];

section application;

In the failed one, my script is like:

Section Access;

LOAD * inline [

ACCESS, USERID,"Job Title",JobTitleDesc, REDUCTION

......

ADMIN, 807037-BI01\operationsuser,'ADMIN','ADMIN',*

......

];

Section Application;

I'm not able to share more data or the sample based on company's policy. Is there anything in the script doesn't seem right?

Any advice helps! Thanks in advance!

1 Solution

Accepted Solutions
Quy_Nguyen
Contributor III

Re: section access not working

May be your field name in section access is the cause.

Ref:

As the same internal logic that is the hallmark of Qlik Sense is also used in the access section, the security fields can be put in different tables. All the fields listed in LOAD or SELECT statements in the section access must be written in UPPER CASE. Convert any field name containing lower case letters in the database to upper case using the Upper function before reading the field by the LOAD or SELECT statement.

https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/Scripting/Security/manage-securit...

1 Reply
Quy_Nguyen
Contributor III

Re: section access not working

May be your field name in section access is the cause.

Ref:

As the same internal logic that is the hallmark of Qlik Sense is also used in the access section, the security fields can be put in different tables. All the fields listed in LOAD or SELECT statements in the section access must be written in UPPER CASE. Convert any field name containing lower case letters in the database to upper case using the Upper function before reading the field by the LOAD or SELECT statement.

https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/Scripting/Security/manage-securit...