topic sheet security access in QlikView

sheet security access

Fri, 17 Apr 2009 21:47:37 GMT

Hi everyone,

I am trying to limit sheet access to a selection of users. I already have an permissions tab in the script to enable access to the complete document.

In sheet properties I was trying to use this in conditional : qvuser() = username

I thought this worked but when it went to the server it did not seem to do so.

Can anyone shed some light on this?

Thanks for the help

sheet security access

Oleg_Troyansky — Sat, 18 Apr 2009 02:38:31 GMT

If you already have Section Access, you can link your users to an additional "Group" field and then condition the tabes based on the Group. See example in the Chapter 30.8 in the Reference Manual

Oleg

sheet security access

Mon, 21 Mar 2011 22:44:15 GMT

QVUser can work.

My section access is based on OSUser, so my conditional sheet access formula is:

IF(OSUser( ) = 'Username', 1, 0)

The problem with this solution that if you have more than 1 user you want to show the sheet to, you have to nest an 'if' statement for all of them. I have 4 people I want to show all sheets to, and even this was cumbersome to set up.

I am going to try the other suggested solution first.

sheet security access

Tue, 22 Mar 2011 06:15:31 GMT

Try with:

UPPER(MATCH(qvuser(),'USER1','USER2','USER3'))

Tchau

sheet security access

Tue, 22 Mar 2011 06:20:34 GMT

Please find the attachment. Hope it helps you lot