Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have created an app in Qlik Sense and want to apply section access.
In specific the app is consisted of a star schema and want each user to be able to see their Team only on a table called OM that is the team dimension. I have added a part of code as per below
Section Access;
LOAD * INLINE
[ ACCESS, USERID, Team
ADMIN, EUNET\User1, *
ADMIN,EUNET\User2, *
USER,EUNET\User3, Team1
USER,EUNET\User3, Team2
USER,EUNET\User4, Team2
];
Section Application;
but still the User3 and 4 see all available data. Also, I have placed it before all the other sections in data load editor.
Could someone assist?
Thanks in advance
Hello,
All values & column name must be in upper case.
Regards,
Prashant Sangle
Hi,
The users are I just added examples here and not the actual users. The column name should also be in uppercase? I mean "TEAM" instead of TEAM although the tables name is not in the actual table I want to apply the restriction?