Security Settings at a Sheet Level?

[#1]

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?

[#2 · Accepted solution]

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.

[#3]

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>) "

[Nicole-Smith]

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

[danieloberbilli]

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:

[Gysbert_Wassenaar]

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

• Sheets Security with Section Access
• Section Access - Hide Sheet Level

[#7]

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.

[Nicole-Smith]

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

[#9]

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

[Nicole-Smith]

Use Admin, User1, and User2.