Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Active directory groups to hide/show sheets

Hi,

I am trying to use the active directory groups a user is assigned to to hide/show sheets. Is this possible?

Eric

4 Replies
Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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.

UserIdGroupComments
User1Group1Access only to Sheet1
User2Group1Access only to Sheet1
User3ADMINAccess to all sheets
User4Group2Access only to Sheet2
User5Group2Access only to Sheet2
User6Group2Access 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