topic Re: Can we apply security on button?? in QlikView

Can we apply security on button??

Wed, 09 Oct 2013 09:40:35 GMT

Can we apply security on button??

Re: Can we apply security on button??

salto — Wed, 09 Oct 2013 09:47:35 GMT

Hi,

Yes, please have a look at the General -> Enable Condition box in the button properties.

The button will be enabled or not depending on the condition in the box.

If you need to enable / disable depending on the username, you can try using the OsUser() command in the box:

=Osuser('Domain\Username')

Regards.

Re: Can we apply security on button??

Wed, 09 Oct 2013 10:39:56 GMT

Thanks SALTO ,

But this is not working for me.

=Osuser('Domain\Username')

Re: Can we apply security on button??

salto — Wed, 09 Oct 2013 10:46:50 GMT

Sorry,

I did not write the correct syntax.
In the box, you need to write this;

=(osuser()='DOMAIN\username')

You also need to add at least one action to the button, otherwise it will always be disabled!

Regards

Re: Can we apply security on button??

Gysbert_Wassenaar — Wed, 09 Oct 2013 10:49:54 GMT

Try something like =if(OSUser()='MyDomain\MyUser',1,0). Replace MyDomain\MyUser with the correct domain and user name. If you have more user names that should be considered perhaps you should use section access. Here's an example for sheets, but the same method will work fine for buttons too since they both use the conditional display option of the objects.

Re: Can we apply security on button??

Wed, 09 Oct 2013 12:08:28 GMT

Dear SALTO,

is it possible??.. when i click on button it would ask for Username and Password.