topic Re: Section Access Qlik Sense SaaS in Management & Governance

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

FranciscoQ — Wed, 29 Jan 2025 16:38:32 GMT

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.

Re: Section Access Qlik Sense SaaS

Seanog_Murphy — Wed, 14 Sep 2022 07:20:49 GMT

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

Managing data security with Section Access

Re: Section Access Qlik Sense SaaS

AdamBS — Wed, 09 Feb 2022 07:29:50 GMT

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.

Re: Section Access Qlik Sense SaaS

FranciscoQ — Wed, 14 Sep 2022 07:20:11 GMT

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.