topic Secured sheets in QlikView

Secured sheets

Wed, 27 Apr 2011 13:15:15 GMT

Hi,

Im developing an application in Qlikview 10 now and I want to not show one sheet (a test sheet) for the users, how do I do to make this possible?

Thanks ahead!

Secured sheets

Miguel_Angel_Baeyens — Wed, 27 Apr 2011 13:24:53 GMT

Hi,

When you mean the users you mean everything but you? In that case, use any conditional you can easily change later, like "1=0" or similar.

If not, how are the users identified? You can set a conditional with the OSUser() function as well as shown below:

Match(Upper(OSUser()), 'DOMAIN\ALLOWEDUSER1', 'DOMAIN\ALLOWEDUSER2', DOMAIN\ALLOWEDUSER3') > 0

Hope that helps.

Secured sheets

Wed, 27 Apr 2011 13:51:24 GMT

Hi,

Exactly, users meaning all users except the developers. Is there anywhere I can set this in settings for the sheet or do I need to write some code for that?

Thanks!

Secured sheets

Miguel_Angel_Baeyens — Wed, 27 Apr 2011 14:03:09 GMT

Hi,

You can use that code, taking care of the exact DOMAIN\USERNAME values, (test them with a text object with)

=OSUser()

In the sheet properties (right click on any empty space in your sheet), General, Show Sheet, Conditional).

Hope that helps.

Secured sheets

Wed, 27 Apr 2011 15:42:08 GMT

Cool it works fine, thanks!