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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Difficulties with section access

Hello,

i try to set up a section access for a document for the first time and struggle with it

After some problems with upper case and similar things (seems as if not only fieldnames have to be upper case but field values for reduction too), it now partly works at least.

I still got some trouble with the admin user entry and hope some of you could give me an advice.

I use NTNames loaded from an xlsx file looking like:

ACCESSNTUSERBERECHTIGUNG
ADMINDOMAIN\user1*
USERDOMAIN\user2Finanzen
USERDOMAIN\user2Logistik
USERDOMAIN\user2IT

The document with the section access script does not have a restriction setting in the document properties, but is loaded with binary load into another one - user1 also is the developement user

After binary load the final document has data reduction checked.

When opening the document on access point and User2 only sees his 3 departments regardless of "Strict Exclusion" checked or not.

But i user1 is not working there - if i check Strict Exclusion, the admin user gets an error telling he has no access at all but at least sees the document at the access point - if i uncheck it he has full access on all departements, not only the 3 which are granted by the * - wildcard if i understand the help correctly.

Other users dont see the document at all at access point, so i guess that user1 is at least recognised with his nt name.

On the other side, documentation says, ADMIN users should always see everything - or at least the 3 wildcarded departments

Can anyone explain what went wrong here or where i made some mistakes ?

Ooh and is there a way to hide complete sheets based on section access ?

10 Replies
morganaaron
Specialist
Specialist

Interesting - as far as I knew, this shouldn't affect data choices and what does/doesn't get seen by an admin, it was meant to be about functionality! Would you mind sharing your whole script, or at least your separated section access and section application containing your reduction field?