Active directory groups to hide/show sheets

[#1]

Hi,

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

Eric

[#2]

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

[#3]

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

[marcus_sommer]

See here: http://community.qlik.com/search.jspa?q=section+access+sheet

- Marcus

[#5]

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