How to implement Section Access in Qlik Sense SaaS or Qlik Cloud

[FranciscoQ]

Hi, I am trying to implement Section Access in Qlik Sense SaaS, in order to filter the information according to the user accessing the app.

I put in the script something like this:

Section Access;

Load * INLINE [

ACCESS, USER.EMAIL, REDUCTION
Professional, 123@grupo123.com.ar, 1
Professional, 456@grupo123.com.ar, 2
Analyzer, 789@grupo123.com.ar, 3
Analyzer, 1011@grupo123.com.ar, 4
];

Section Application;

DataReduction:
Load * INLINE [
REDUCTION, Unit
1, *
2, Beverages
3, *
4, Canned
] ;

But when I run the script it says that I don't have access to load it. I put an * in UNIT.

Maybe in the ACCESS column, I have to put ADMIN, USER? I put Professional, and Analyzer because those are the Qlik Sense SaaS Access.

[Seanog_Murphy · Accepted solution]

Hi @FranciscoQ 
Please see the example in the article below:

• Managing data security with Section Access

[AdamBS]

The support reply above is good. You will see that, as you say, in the ACCESS column you can only have ADMIN or USER as values. 

[FranciscoQ]

Yes, there were two things I was needing to change. Instead of Professional, Analyzer, I was supposed to use ADMIN and USER.

Also, the use of the wildcard "*", is not intended for all the values in the field you are trying to filter according to the user, but for all the values that exist in the data reduction table. 

This explanation by Dalton Ruer helped me really good to find the issues:

Making Sense of Section Access in Qlik Sense

In my opinion the official article, for someone who never used section access before, is kind of hard to follow.  But after reading the Dalton explanation makes more sense.