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: 
vanderson009
Creator III
Creator III

SectionAccess

Hi,

I have written code for SectionAccess but that was not working.

So pleas help me regarding section access, i have written following script.

Section Access;
LOAD INLINE [
ACCESS, USERID, PASSWORD, DEPTNO
ADMIN, ADMIN, admin,
USER, user1, user1, 001
USER, user2, user2, 002

USER, user3, user3, 003];
Section Application;


LOAD * Inline [
DEPTNO,DNAME

001, Marketing

002, Sales

003, Research];

Thanks and Regards,

Anderson

1 Solution

Accepted Solutions
VishalWaghole
Specialist II
Specialist II

Hi Anderson,


Please Go To.....


Setting ----> and Open Document Properties


Under Document Properties Select Opening Tab.


In Opening tab just check where Initial Data Reduction Based on Section Access option

is enable or disable. If its disable then make it enable and under this option make

Strict Exclusion option is disable.


Thanks

V Waghole

View solution in original post

4 Replies
Not applicable

Hi Anderson,

With your current script you are only loading the users and department atribute but it doesn't apply it to anything.

You could apply this on department for sure. Do you have a department kolum in your current datamodel?

If yes please, what is the exact kolumname and fieldcontent? So i can rebuild your SA script. If not, please add the aggregation level in your datamodel.

VishalWaghole
Specialist II
Specialist II

Hi Anderson,


Please Go To.....


Setting ----> and Open Document Properties


Under Document Properties Select Opening Tab.


In Opening tab just check where Initial Data Reduction Based on Section Access option

is enable or disable. If its disable then make it enable and under this option make

Strict Exclusion option is disable.


Thanks

V Waghole

Luis_Cortizo
Former Employee
Former Employee

I can't find any problem with your code. After copying and pasting the code on a QV Document (attached) it seems to work fine.

When I open the QlikView document with the admin user:

Admin.PNG.png

And with the USER2 user:

User2.PNG.png

Please, make sure that you have checked the following options under Settings => Document Properties:

OptionsOpening.PNG.png

Luis_Cortizo
Former Employee
Former Employee

Just a quick comment; the strict exclusion check is used when reducing the data.


If the field values on the section access don't match with any field on the section application the access to the document will be denied (except for users that have ADMIN on the ACCESS column).


Meaning that if with modify the code provided by Villyee as:


Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, DEPTNO

    ADMIN, ADMIN, admin

    USER, user1, user1, 001

    USER, user2, user2, 002

    USER, user3, user3, 003

    USER, user4, user4, 090

];

Section Application;

The user user4 will not be able to access the QlikView document even if it is on the Section Access table as there's no DEPTNO 090 on the data model.