Section Access to restrict rows

[johnnyjohn]

Hello, 

I'm trying to implement section access, all the guides I see online seem to be overly complicated. 

The use case is quite simple. I have the below table between salesman and client. 

• When user with name 'fletch' logs in, I want them to only see the data where 'salesman = Tom',
• When user with name 'stall' logs in, I want them to only see the data where 'salesman = Bob'
• When user with name 'garris' logs in, I want them to only see all the data. 

How can I set this up? Thanks a lot

salesman	client
Tom	Client1
Tom	Client2
Tom	Client3
Bob	Client4
Bob	Client5
Ross	Client6

[Qlik1_User1]

@johnnyjohn Try below.

Section Access;
LOAD * INLINE[
ACCESS, USERID,KEY
USER,FLETCH,TOM,
USER,STALL,BOB,
USER,GARRIS,*
];
Section Application;

In your fact use UPPER(Salesman) as KEY

[johnnyjohn]

Dont think this is right - should be LOAD * INLINE and USERID

Still doesnt work though

[Qlik1_User1]

@johnnyjohn Can you share your script you have used.