topic Re: sheet level security in QlikView

sheet level security

vireshkolagimat — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have qlikview document and it contains 3 sheets namely Report, Analysis and Dashboard.

My requirement is when a person with admin access open the QVW file, he should be able to see all the 3 sheets.

And if user1 opens the QVW, he should see only Reports sheet and user2 should see Analysis.

How to achieve the same.

We can create a section access using the below script but how to make the above changes.

Section Access;

LOAD * INLINE [

ACCESS, USERID

admin, admin

user, user1

user, user2

];

Section Application;

Thank you.

Regards,

Viresh

Re: sheet level security

stabben23 — Wed, 25 Jan 2017 10:24:04 GMT

Hi,

there should be a lot of example here if you search on sheet Level sequrity in the community

Re: sheet level security

rohitk1609 — Thu, 16 Feb 2017 09:45:52 GMT

Hi,

To implement sheet level access step by step or more deep level App objects level access please refer this document:

Sheet or App Object Level Security Qlik Sense

Re: sheet level security

MayilVahanan — Thu, 16 Feb 2017 09:50:40 GMT

Hope it wil help you

Type of Security

Re: sheet level security

rahulpawarb — Thu, 16 Feb 2017 10:37:23 GMT

Hello Viresh,

Please follow below given steps:

1. Open the application and go to the Edit Script section

2. Select Create Hidden Script option from File Menu

3. Set Password for the same

4. Paste below given sample script

Section Access;
LOAD * INLINE [
    ACCESS, USERID, PASSWORD
    ADMIN, ADMIN, ADMIN123
    USER, USER1, USER111
    USER, USER2, USER222
];
Section Application;
LOAD * INLINE [
USERID,SHEETNO
ADMIN, 1
USER1, 2
USER2, 3
];

5. Place the cursor at the bottom of Main tab and paste below given sample script

Security_Ref:
LOAD * INLINE [
SHEETNO, Dashboard, Analysis, Reports
1, 1, 1, 1
2, 0, 0, 1
3, 0, 1, 0
];

6. Now save the changes and hit Reload button

7. Change the Show Sheet - Conditional settings for every sheet as -

//Dashboard Sheet

=Dashboard

//Analysis Sheet

=Analysis

//Reports Sheet

=Reports

8. Once this is done then open the document properties (Ctrl + Alt + D) and tick below options present on Opening tab.

Initial Data Reduction Based On Section Access

Strict Exclusion

9. Save the application and close.

Now, while opening the document application will ask for credentials. Enter the respective credentials to get the desired results.

P.S.: Password for Hidden Script - loginme

Regards!

Rahul

Re: sheet level security

vardhancse — Thu, 16 Feb 2017 10:46:59 GMT

Hi follow below steps:

Step 1:

Write below code in script editor

SECTION ACCESS;

Access:

LOAD ACCESS,

NTNAME

FROM

[Section_Access.xlsx]

(ooxml, embedded labels, table is Access);

SECTION Application;

star is *;

Security:

LOAD NTNAME,

NAME,

REPORT,

ANALYSIS,

DASHBOARD

FROM

[Section_Access.xlsx]

(ooxml, embedded labels, table is Security);

IN EXCEL MAINTAIN BELOW DATA:

NTNAME NAME REPORT ANALYSIS DASHBOARD

NAME1 1 1 1 1

NAME2 1 0 0 0 //NAME SHEET

NAME3 0 1 0 0 //REPORT SHEET

NAME3 0 0 1 0 //ANALYSIS SHEET

NAME4 0 0 0 1 //DASHBOARD SHEET

Step 2:

In the sheet properties change the name from

Sheet1 to ANALYSIS

Sheet2 to REPORT

Sheet3 to DASHBOARD

Step 3:

Sheet properties->General->Show Sheet->Condition

=ANALYSIS

similarly for rest of the sheets as REPORT AND DASHBOARD

reload and your requirement was done