Discussion board where members can learn more about Qlik Sense App Development and Usage.
Hi there !
I'm completely new to Qliksense and I'm quite confuse with the section access system (i, Qsense enterprise) .Here is my problem.
I have 4 SQL tables:
Reading the help, I guess I don't even have to bother with the first 2 tables. The role_user should be enough to handle the security.
If I got it right, the section access should looks like:
LIB CONNECT TO [myserver(myaccount)];
LOAD [USERID, GROUPID
SQL SELECT "User_ID" , "GroupID"
LOAD... the dataTable that contains the data fields and the GroupID field
And of course, It dosent work.
Could someone gives me a simple example of what need to be done ?
Thank you very much in advance.
The syntax is wrong. You need to remove the square brackets and change to upper case:
LOAD USERID, GROUPID ;
SQL SELECT "User_ID" as USERID, "GroupID" as GROUPID
Further, you need to have a reducing field also - a field that links the table(s) in Section Access to the real data. Is this the GROUPID, or?
See A Primer on Section Access. This post is about QlikView and not Qlik Sense, but most things are the same. The only difference is really that NTNAME is replaced by USERID and GROUP.
Thank you for your fast answer !
It is indeed GROUPID that I intended to use as the reducing field.
I will read your link carefully.
thanks again !