Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
vinay_skpk
Partner
Partner

Section Access is Denied

Hi,

I am  applying section access with multiple fields .After reload, the app is displaying as "Access Denied" for the user.

Is there a way to exclude Strictly Prohibit feature in Qlik Sense Section access.

3 Replies
NadiaB
Support
Support

Hi @vinay_skpk 

The Strict Exclusion is on by default in Qlik Sense.

Could you provide a sample of your Section Access? 

We also recommend the following documentation:

Managing security with section access

 

Note: if this suggestion helps to resolve the issue or answers your question, it will be appreciated if you select the "Accept as Solution" option.
We encourage you to visit our Knowledge Base https://qliksupport.force.com/QS_CoveoSearch when trying to find a solution related and not limited to: errors, feature requests, product defects. You can also visit our Qlik Help portal https://help.qlik.com/
vinay_skpk
Partner
Partner
Author

Hi Nadia,

below is the sample table we are trying to use.  In the below scenario we want A and B to access based on the restriction but C to access all data.  we have 13 regions. by giving * C is getting only APAC as region, India and China as Country.  The data access C is getting is only Union of field values we have given in the script where as he needs all fields available in the Data base to access.  

UserIDRegionCountryCityProduct
AAPACChinaBejiengSoftware
BAPACIndiaDelhiServices
C****

 

What should be specified instead of * to get all fields loaded for C.  Any help will be great.

 

Regards,

Vinay

NadiaB
Support
Support

Hi @vinay_skpk 

Have you had the chance to look into the documentation?

The behavior is working as designed, * will show all listed:

The wildcard, character *, in this row refers only to all values within the section access table. If there are values in the section application that are not available in the REDUCTION field in section access, they will be reduced.

You could either ensure all the values are in the current table or you can create profiles and then assign those profiles to the users:

 

Section Access;

LOAD * INLINE [
ACCESS, USERID, PROFILE
ADMIN, DOMAIN\ADMINISTRATOR, ALL
USER, DOMAIN\USER1, APAC
USER, DOMAIN\USER2, EMEA
USER, DOMAIN\USER3, ALL
];

LOAD * INLINE [
PROFILE, REGION
APAC, APAC
EMEA, EMEA
LATAM, LATAM
ALL, APAC
ALL, EMEA
ALL, LATAM
];

Section Application;

LOAD * INLINE [
REGION, SALES
APAC, 1000
EMEA, 2000
LATAM, 3000

];

 

Hope it helps.

 

Note: if this suggestion helps to resolve the issue or answers your question, it will be appreciated if you select the "Accept as Solution" option.
We encourage you to visit our Knowledge Base https://qliksupport.force.com/QS_CoveoSearch when trying to find a solution related and not limited to: errors, feature requests, product defects. You can also visit our Qlik Help portal https://help.qlik.com/