topic Active directory groups to hide/show sheets in QlikView

Active directory groups to hide/show sheets

Wed, 19 Feb 2014 10:35:45 GMT

Hi,

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

Eric

Re: Active directory groups to hide/show sheets

Wed, 19 Feb 2014 10:42:00 GMT

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

Re: Active directory groups to hide/show sheets

Wed, 19 Feb 2014 10:51:55 GMT

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

Re: Active directory groups to hide/show sheets

marcus_sommer — Wed, 19 Feb 2014 11:44:22 GMT

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

- Marcus

Re: Active directory groups to hide/show sheets

Thu, 20 Feb 2014 08:02:47 GMT

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