topic Re: sheet level security in QlikView

sheet level security

ssriramin19 — Wed, 09 May 2018 17:01:06 GMT

Hello everyone,

This is my requirement . In a dashboard I have total six sheets. Sheet names are

Home, study, supplier,Services ,Qualifications Status,admin .

There are three security groups being created for this purpose,

1.CSTP-Public Report-Prod - Users part of this group would be able to see sheets till services .

2. CSTP-Qualification Report-Prod - User part of this group would be able to see sheets till Qualifications .

3.CSTP-Admin-Prod - User part of this group would be able to see all the sheets .

Can any one please tell me how to implement security in sheets according to groups being created .

Thanks

Sriram

ssriramin19 — Wed, 09 May 2018 17:36:51 GMT

can anyone please tell me how to implement sheet level security?

ssriramin19 — Thu, 10 May 2018 03:42:01 GMT

Can any one please help me how to achieve the security with the above requirements.

Thanks

Sriram

Anonymous — Thu, 10 May 2018 08:39:10 GMT

You need to create excel for sheet level security:

User SheetID

XYZ 1

ABC 0

And load in your script after that put sheet level condition in sheet properties that sheetID>0.

Thanks

shiveshsingh — Thu, 10 May 2018 09:45:16 GMT

You can implement it by marking required sheets as 1 for the group you want to display and rest as 0.