Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

OSUser command not working to hide a sheet

I'm using

= OSUser() <> 'domain\username' OR

OSUser() <> 'domain\username'

as a condition in the sheet properties and it's not hiding it to other users.  I already checked the sheet/document security and made sure "Show all Sheets and Objects' box is unchecked.

Any ideas??

Thanks.

1 Solution

Accepted Solutions
Not applicable
Author

I found the right syntax from another post

=MixMatch(OSUser(),

   'domain\user'  ,

'domain\user'

   

)

View solution in original post

2 Replies
Anonymous
Not applicable
Author

Create a text object with content

=OSUser()

and see what the result is.  You'll figure out the rest.  Maybe upper(OSUser())=upper(domain\username) will work.

Next, looks like you want to hide the sheet for everyone, isn't it?  In this case you can use condition: 0.

Regards,

Michael

Not applicable
Author

I found the right syntax from another post

=MixMatch(OSUser(),

   'domain\user'  ,

'domain\user'

   

)