topic Re: Conditional Show Based on OSUser in QlikView

Conditional Show Based on OSUser

Anonymous — Mon, 15 Jun 2015 16:25:03 GMT

Trying to add a conditional statement to a button based on OSUser

Currently, I have the following syntax in the SHOW/Conditional dialouge box of the button:

OSUser () = '*melillo*, *userlastname*'

This does not seem to be working, even when I try it with just my last name.

Any suggestions? Thank you.

Re: Conditional Show Based on OSUser

petter — Mon, 15 Jun 2015 16:29:24 GMT

You should be able to use the WildMatch() function like this:

WildMatch( OsUser() , '*melillo*', '*userlastname*' )

Re: Conditional Show Based on OSUser

Anonymous — Mon, 15 Jun 2015 16:31:10 GMT

Thanks Petter.

Re: Conditional Show Based on OSUser

cbaqir — Thu, 18 Feb 2016 16:45:05 GMT

Petter,

On my Sheet Properties for Validation, I have Show Sheet Conditional:

=WildMatch( OsUser() , '*cbaqir*', '*jbrowning002*', '*clondono*','*draffensperger*' )

However, as you can see in the screenshot, this user can see this sheet but should not be able to. Any idea why? Does the type of license or distribution make a difference?

Thanks,

Cassandra