Secured sheets

[#1]

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!

[Miguel_Angel_Baeyens]

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.

[#3]

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!

[Miguel_Angel_Baeyens · Accepted solution]

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.

[#5]

Cool it works fine, thanks!