topic Re: QlikSense Security rule for sheets in Management & Governance

QlikSense Security rule for sheets

kp072017 — Thu, 30 Aug 2018 05:24:47 GMT

Hi All,

Please let me know if we can create a security rule for restricting sheets in an App for some particular users.

Like some sheets must be visible to one particular user and other sheets to second user.

Please let me know.

Thanks in Advance.

Karthik

Re: QlikSense Security rule for sheets

arvind1494 — Thu, 30 Aug 2018 05:51:45 GMT

create appliation with sheet names as

Sheet1 and Sheet2

then use following code as section access

Section Access;

LOAD * INLINE [

ACCESS, USERID

Admin, A

User, B

User, C

USer, D

];

Section Application;

SheetAccessMatrix:

LOAD upper([USERID]) as [USERID],

Sheet1,

Sheet2

FROM

sheetlevel.xlsx

(ooxml, embedded labels, table is Sheet1);

Note:sheetlevel.xlsx (in attachment)

otherwise create excel with following data:

USERID	Sheet1	Sheet2
A	1	1
B	0	1
C	1	0
D	1	1

Re: QlikSense Security rule for sheets

kp072017 — Thu, 30 Aug 2018 06:02:08 GMT

Hi Arvind,

Thank you for the response.

We will check once about the resolution you provided. The attachment was missing in the reply you provided.

Also please let me know if we can restrict user through security rules for sheets.

Thanks,

Karthik

Re: QlikSense Security rule for sheets

boraste-sagar — Thu, 30 Aug 2018 06:03:36 GMT

Hi Karthik By default, the user who have access in stream will have access for all sheets. You will need to change the default policies as described above Sheet or App Object Level Security Qlik Sense

Re: QlikSense Security rule for sheets

arvind1494 — Thu, 30 Aug 2018 06:14:24 GMT

My suggested approach to implementing Sheet Level Security is to create four new Security Rules after disabling the default rules. It involves a User Directory with properties for the Company, Application, and Sheets. Custom properties in the QMC will need to be created to contain the same User Directory property values.

Custom properties are created, in the QMC, and assigned to the individual Applications and Streams. This allows for a general approach to handling an expanding list of Companies and their various Applications. As the number of Applications and Companies grow, the User Directory Properties and Custom Properties will both need to be updated to grant access to the new applications and the application's sheets.

Security Rule to Disable is the Stream rule...

Rule Name = Stream

Resource Filter = App*

Rule for Sheets

Filter = App.Object_*
Suggested Logic = Identify a group of QlikSense Users who meet the criteria to access the sheets.
1. The Object must be a sheet
2. The Users must have the user property of sheets that matches the Sheet Name

((

user.userDirectory="Specific User Group"

and resource.objectType="sheet"

and user.sheets=resource.name

))