topic Re: Security Settings at a Sheet Level? in QlikView

Security Settings at a Sheet Level?

Wed, 18 Dec 2013 16:15:28 GMT

I know that you can set security settings based on fields, but I am trying to set security at a tab/sheet level. I have about 50 people that need access to a file and approx 15 tab/sheets within that file. I have identified 6 groups that I need to assign people based on what tabs they can have permissions to see. Does anyone know if it is possible to assign security on a tab/sheet and how to go about doing it?

Re: Security Settings at a Sheet Level?

Wed, 18 Dec 2013 16:25:07 GMT

You can use the conditional "Show Sheet" option in the sheet properties combined with the OSUser() or QVUser() functions to specify who can see the sheet, e.g. OSUSer() = 'domain\account' if using AD to authenticate. I think groups are supported too.

Re: Security Settings at a Sheet Level?

Wed, 18 Dec 2013 16:26:48 GMT

we had a similar requirement couple of months back and we did with show sheet condition as we did not find any security feature from Qlikview "=match(upper(OSUser()), <You list of users>) "

Re: Security Settings at a Sheet Level?

Nicole-Smith — Wed, 18 Dec 2013 16:33:22 GMT

Here is an example .qvw (check out the load script as well as the conditionals on the sheets).

Re: Security Settings at a Sheet Level?

danieloberbilli — Wed, 18 Dec 2013 16:33:29 GMT

I think there is no real security assignment on sheets as with fields and data but you could use the Conditional Show Sheet in the Sheet Properties and use your people/group identifier:

Re: Security Settings at a Sheet Level?

Gysbert_Wassenaar — Wed, 18 Dec 2013 17:09:09 GMT

You can use section access to limit access to sheets. There are several discussions around with examples. And perhaps these documents help:

Re: Security Settings at a Sheet Level?

Thu, 19 Dec 2013 16:05:10 GMT

We ended up using =match(OSUser() and it worked because it can identify the user when they login, but we would rather use the Group= instead. The problem I'm having with that is when I want someone from Groups 2&6 to see the file, I am not sure how it will link it with the OSUsername. I uploaded a file that had the person's name, Group #, and what their OSUer name is. When I typed in Group = 1, which happens to be the Group I am in, it doesn't register or link with OSUser field I believe, as it hid the sheet from me instead of letting me see it. Likewise, if I chose Group =1,6 a coworkers who was not in either group was still able to see it.

Do you know to make it link so that we can use the groups? Do I need to use some type of if statement where I'd say if the Group = 1, 6 then these OSUsers? This would be the best option if we can do that.

Re: Security Settings at a Sheet Level?

Nicole-Smith — Thu, 19 Dec 2013 16:38:46 GMT

I gave an example of how to use groups in my post above...

Re: Security Settings at a Sheet Level?

Thu, 19 Dec 2013 18:15:20 GMT

Hi Nicole, it is not allowing me to open the file. It is asking for login ID.

Re: Security Settings at a Sheet Level?

Nicole-Smith — Thu, 19 Dec 2013 18:23:34 GMT

Use Admin, User1, and User2.