Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
FranciscoQ
Partner - Creator
Partner - Creator

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

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.

 

Labels (5)
1 Solution

Accepted Solutions
Seanog_Murphy
Creator III
Creator III

3 Replies
Seanog_Murphy
Creator III
Creator III

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

AdamBS
Partner - Contributor III
Partner - Contributor III

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. 

Adam Barrie-Smith
iOCO Analytics Solutions
FranciscoQ
Partner - Creator
Partner - Creator
Author

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.