Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to use the active directory groups a user is assigned to to hide/show sheets. Is this possible?
Eric
You can simple add windows id's of the users to sheet hide/show condition by using
OSUser() = DOMAIN\Windows id
Hope this helps!
Regards,
Neha
thanks for your message neha. however i am looking to use a specific group a user is assigned to active a sheet. is that possible? it doesnt seem to work for me.
Eric
See here: http://community.qlik.com/search.jspa?q=section+access+sheet
- Marcus
Qlikview doesn't work for group of users defined in active directory when it comes to sheet level or data level security. You have to define the group within script itself and then use that field or variable to add conditions at sheet level.
Here is an example:
Suppose, there are 2 sheets and 6 users, each has access defined to particular sheet.
UserId | Group | Comments |
User1 | Group1 | Access only to Sheet1 |
User2 | Group1 | Access only to Sheet1 |
User3 | ADMIN | Access to all sheets |
User4 | Group2 | Access only to Sheet2 |
User5 | Group2 | Access only to Sheet2 |
User6 | Group2 | Access only to Sheet2 |
Then define conditional show:
Sheet1: If(Group=Group1 or Group=ADMIN, 1,0)
Sheet2: If(Group=Group2 or Group=ADMIN, 1,0)
Hope this helps you!
H2H,
Neha