Unable to get Section Access Working in Qlik Sense

[#1]

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,

......

[satishkurra]

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 · Accepted solution]

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]

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

[#5]

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