topic OSUser command not working to hide a sheet in QlikView

OSUser command not working to hide a sheet

Thu, 02 Aug 2012 21:06:17 GMT

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.

Re: OSUser command not working to hide a sheet

Anonymous — Thu, 02 Aug 2012 23:44:43 GMT

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

Re: OSUser command not working to hide a sheet

Fri, 03 Aug 2012 13:05:16 GMT

I found the right syntax from another post

=MixMatch(OSUser(),

'domain\user' ,

'domain\user'

)