Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

SECTION access with 2 USER ID entries

HI All

I'm struggling with section access where I have implemented the code as below:

section access;

Star is *;

LOAD * inline [
ACCESS, USERID, MA, MO1, MO2, MO3
ADMIN, DOMAIN\pshastr2, , PRATYUSH, , 
ADMIN, DOMAIN\pshastr2,  PRATYUSH, , ,
ADMIN, DOMAIN\nbafna2, NILESH, , ,
ADMIN, DOMAIN\psahoo11, , PRAVAT , 
];

section application;

UserDetails:
Load * Inline [
MA, MO1, MO2, MO3
NILESH, PRATYUSH, SANDEEP, GAURAV
NILESH, SANDEEP, PRATYUSH,  GAURAV
NILESH, PRAVAT, PL, BB
NILESH, UMESH, TX, TY
];

 

When I'm logging in as DOMAIN\pshastr2, I should only see the first two records of my inline table, but I'm seeing all the records. What is wrong here? Please guide

 

Regards

Pratyush

1 Reply
Highlighted
Partner
Partner

Re: SECTION access with 2 USER ID entries

 

 

Section Access Example.pngOnce the section access code it put int the edit script.

You need to check the above options from the document properties to reduce the data as per the requirement.