Discussion board where members can get started with Qlik Sense.
I have created a custom property called GROUP in the qmc, which can either have the value G1 or G2. I have assigned this custom property to my users, some of them have G1, others G2.
My application has a dimension called DIM , which can have the values "A", "B" and "C".
I want to restrict all users who are in GROUP G1 (i.e. have the custom property value G1) to view all data that is connected to DIM values "B" or "C".
I also want to restrict all users who are in G2 to view every data that is connected to "A" or "C".
I have managed to make the section access work by defining the following inline table for each user manually.
LOAD * inline [
ACCESS, USERID, DIM, OMIT
USER, DOMAIN1\peter, "A",
USER, DOMAIN\max, "B",
But how can I define my behavior by means of Custom Properties?
I have tried this one as shown in the qliksense help page (*) but it gives me "Access denied" to every user:
ACCESS, USERID, GROUP, DIM, OMIT
USER, *, G1, "A",
USER, *, G2, "B",
Go to Solution.
you can't use Custom Properties with Section Access.
you can achieve your request using the script below:
LOAD * INLINE [
ACCESS, USERID, PASSWORD, NTNAME, USERGROUP
USER, *, *, DOMAIN1\PETER, G1
USER, *, *, DOMAIN\MAX, G2
ADMIN, TEST, TEST, *, *
Thanks a lot for the quick response!
I dont remember that one has to use PASSWORD and NTNAME in the QlikSense sectionaccess. Aren't they used in QlikView?
What is NTNAME ?
Section Access fields are a bit different in Sense.
However NTNAME is the windows domain user account or even the windows local user account.
Section Access is for Data level security.
QMC security is not.
You'd have to do it manually as you did, associate an NTName (USERID) with a group/value.
What you did originally is correct. There seem to be no other way I know of.
please close this thread if you think has been answered.