4 Replies Latest reply: Nov 22, 2016 10:41 AM by Balaji Ravichandran RSS

    Qlik Sense Section Access Script

    Simone Trabattoni

      Hi community,

      I'm working on section access part of the script in Qlik Sense (logically not Qlik Sense Desktop).

      My situation is described here

      https://community.qlik.com/thread/198691?sr=stream

      I've read the documentation,

      https://help.qlik.com/sense/1.1/en-US/online/index.html#../Subsystems/Hub/Content/Scripting/Security/ManagingSecurityWithSectionAccess.htm

      and also some discussions.

      My problem is this.

      I've those datas

       

      table:

      Load

      chief,

      Upper(agent) as AGENT,

      performance

      inline

      [

      chief,agent,performance

      alfa,BETA1,5

      alfa,BETA2,4

      ]

      ;

       

      I've put Upper(agent) instead of agent because I suppose to understand that for section access you should use upper case (to avoid any mistake, probably I've put some superflous uppercases).

       

      Now I got three users, ID1, ID2, ID3.

      I would like that ID1 could see only the data referred to BETA1, ID2 could see only the data referred to BETA2, and ID3 could see everything, so I decide those restriction:

       

      section access;

      Load *

      inline [

      ACCESS, USERID,AGENT

      USER,ID1,BETA1

      USER,ID2,BETA2

      USER,ID3,*

      ];

       

      section application:

      LOAD

      BETA1 AS REDUCTION,

      BETA2 AS REDUCTION;

       

      I reload the data, but after closing the app and re-opening it, the result is a pop-up of Access Denied (the translation should be "An error occurs, access denied").

       

      error.PNG

       

      So, how can I fix it?

      Thanks a lot!