Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with setting up access

Hi everyone,

I have set up a hidden access script, see it below:

Section Access;
LOAD ACCESS,
NTNAME,
USER,
CC_Description
FROM
[\\auqldrv00fil1bi\work\qlikview\Corporate Accounting\SG&A Report\MasterData.xlsx]
(
ooxml, embedded labels, table is Access);

Section Application;


and I have attached the masterdata spread sheet where is looking the data for the security.

I would like to have it user only seeing your department and only some users to see everything.

however it is not working and everyone can see everything. The way I am filtering it is based on the CC_description which is in my data scrip as a group.

maybe that is the reason? does anyone has any light?

Thanks so much

5 Replies
micheledenardi
Specialist II
Specialist II

Have you checked the relatives checkbox in order to "enable" the section access restriction ?

4ca0c4b4-3e4d-4e9c-87a5-dd49043ef52e.png

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Are the CC_description values in your DD_GL table in Section Application all in upper case? If not, create a copy of that field with the UPPER() function, call it CC_DESCRIPTION_SA and rename the corresponding Section Access field to CC_DESCRIPTION_SA

Peter_Cammaert
Partner - Champion III
Partner - Champion III

In section Access, both the field names and their values are silently converted to upper case. That's a side effect of Section Access...

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Also, IIRC enabling Data reduction and Strict exclusion but without having a proper link field means NO REDUCTION AT ALL... Nice huh?

sibusiso90
Creator III
Creator III

Hi Joana

Please find the following it will help you with any security you need to do. While I look at your definitions. It will come in handy in future as well