Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
ssriramin19
Contributor III
Contributor III

sheet level security

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

4 Replies
ssriramin19
Contributor III
Contributor III
Author

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

ssriramin19
Contributor III
Contributor III
Author

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

Thanks

Sriram

sumi1991
Contributor
Contributor

Hi

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
Master
Master

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

please refer Sheet Level Security.qvw