Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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'

   

)