Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Secured sheets

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!

1 Solution

Accepted Solutions
Highlighted

Secured sheets

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.

View solution in original post

4 Replies
Highlighted

Secured sheets

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.

Highlighted
Not applicable

Secured sheets

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!

Highlighted

Secured sheets

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.

View solution in original post

Highlighted
Not applicable

Secured sheets

Cool it works fine, thanks!