Discussion Board for collaboration related to QlikView App Development.
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 .
can anyone please tell me how to implement sheet level security?
Can any one please help me how to achieve the security with the above requirements.
You need to create excel for sheet level security:
And load in your script after that put sheet level condition in sheet properties that sheetID>0.
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