johnnyjohn
Creator
2024-10-03
04:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Section Access to restrict rows
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 |
3 Replies
Qlik1_User1
Specialist
2024-10-03
04:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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
217 Views
johnnyjohn
Creator
2024-10-03
04:59 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dont think this is right - should be LOAD * INLINE and USERID
Still doesnt work though
207 Views
Qlik1_User1
Specialist
2024-10-03
05:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@johnnyjohn Can you share your script you have used.
189 Views