Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Section Access with 2 USERID 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

4 Replies
Highlighted
Partner
Partner

Re: Section Access with 2 USERID entries

IMG_20190131_202923.jpg

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted
Specialist
Specialist

Re: Section Access with 2 USERID entries

I even tried this, on Putting access as USER, it says Access Denied. I can't understand why this is happening.

Regards
Pratyush
Highlighted
Partner
Partner

Re: Section Access with 2 USERID entries

My guess is that you have not have a match for all SA reduction fields. I notice that you kept many of the reductions empty, you should define them explicit. (You could use start *, but make sure you use it correctly.)
Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted
Specialist
Specialist

Re: Section Access with 2 USERID entries

Hi Vegar

I even tried with that, but it is still showing all the data. It is behaving very absurdly, and I'm not able to understand why did it say access denied when I gave the access as USER instead of ADMIN.

Very confused, don't know how to move forward on this.

Regards

Pratyush