Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Partner
Partner

QlikSense Security rule for sheets

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

4 Replies
arvind1494
Valued Contributor

Re: QlikSense Security rule for sheets

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:


 

USERIDSheet1 Sheet2
A11
B01
C10
D11
Partner
Partner

Re: QlikSense Security rule for sheets

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

boraste-sagar
New Contributor III

Re: QlikSense Security rule for sheets

  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

arvind1494
Valued Contributor

Re: QlikSense Security rule for sheets

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

    1. Filter = App.Object_*
    2. 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

))