Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Unable to get Section Access Working in Qlik Sense

Hi,

I have been trying to restrict certain users for certain data sets but it does not seem to work.I have tried to check for the case and everything seems to be okay but when I try this get access denied.Appreciate any help on this.

My code is:

section access;
load * inline [
UPPER(ACCESS) as ACCESS, UPPER(USERID) as USERID,UPPER(REDUCTION) as REDUCTION
USER,DOMAIN\SJANARDHAN,D1550
USER,DOMAIN\VKALLURI,D1500

];

Fact Data:

Section Application;

Load product,department,

UPPER("department") as REDUCTION,

......

1 Solution

Accepted Solutions
pablolabbe
Valued Contributor II

Re: Unable to get Section Access Working in Qlik Sense

Hi Sujan,

  The correct use of the inline clause is :

section access;
LOAD
     UPPER(ACCESS) as ACCESS,

     UPPER(USERID) as USERID,

     UPPER(REDUCTION) as REDUCTION

inline [

ACCESS, USERID, REDUCTION
USER,DOMAIN\SJANARDHAN,D1550
USER,DOMAIN\VKALLURI,D1500

];

  if you use the functions inside the brackets, the function will be part of the column name and will not match the special names allowed for a section access table.

4 Replies
satishkurra
Valued Contributor II

Re: Unable to get Section Access Working in Qlik Sense

try this

section access;
load * inline [
UPPER(ACCESS) as ACCESS, UPPER(USERID) as USERID,UPPER(REDUCTION) as REDUCTION
USER,DOMAIN\SJANARDHAN,D1550
USER,DOMAIN\VKALLURI,D1500

];

Section Application;

Fact Data:

Load product,department,

UPPER("department") as REDUCTION,

pablolabbe
Valued Contributor II

Re: Unable to get Section Access Working in Qlik Sense

Hi Sujan,

  The correct use of the inline clause is :

section access;
LOAD
     UPPER(ACCESS) as ACCESS,

     UPPER(USERID) as USERID,

     UPPER(REDUCTION) as REDUCTION

inline [

ACCESS, USERID, REDUCTION
USER,DOMAIN\SJANARDHAN,D1550
USER,DOMAIN\VKALLURI,D1500

];

  if you use the functions inside the brackets, the function will be part of the column name and will not match the special names allowed for a section access table.

satishkurra
Valued Contributor II

Re: Unable to get Section Access Working in Qlik Sense

Also Section Application is ending in Fact Table which should not be the case

Not applicable

Re: Unable to get Section Access Working in Qlik Sense

Thanks Pablo it works now.

One other Q I have is can I put in the security on a dimension column at a higher level from the Fact data.For Example currently I have put In the REDUCTION on level 0 department but I want to put in a RECUCTION on a grouping on departments.

Thanks