topic Re: Disable(lock) an object based on user login in QlikView

Disable(lock) an object based on user login

Mon, 11 Aug 2014 05:49:50 GMT

Hi All,

I want to disable an object based on the logged in user.

For users logged in I am using section access.

Basically I am using a textbox with image and added two actions of set variable and Activate sheet.

I want to disable the textbox when a particular users get logged in.

How can I achieve this?? Could anyone help me on this??

Thanks,

Shailesh

Re: Disable(lock) an object based on user login

tresB — Mon, 11 Aug 2014 05:53:49 GMT

Text box right click->Layout tab-> Show conditional: Expression like: =QvUser()<>'UserName'

Re: Disable(lock) an object based on user login

ashfaq_haseeb — Mon, 11 Aug 2014 05:54:07 GMT

Hi.

Right Click on text box -->Layout --> Conditional

and write below code

If(osuser()='Doamin\User',1,0)

Then this will be only visible to user you specify above.

Regards

ASHFAQ

Re: Disable(lock) an object based on user login

sujeetsingh — Mon, 11 Aug 2014 05:55:11 GMT

Looks that you need to take the list of users first from the User table and then use some macros to get the current logged UserID and then locking .

Re: Disable(lock) an object based on user login

simenkg — Mon, 11 Aug 2014 05:55:29 GMT

You can use OSUser() in the conditional show of the text-box.

OSUser() returns DOMAIN\USERNAME.

Re: Disable(lock) an object based on user login

Mon, 11 Aug 2014 05:58:18 GMT

Hi,

In Layout Conditional property you may write If(USER='ABC',1,0)

I think this should work for you.

Re: Disable(lock) an object based on user login

Mon, 11 Aug 2014 05:59:58 GMT

Hi tresesco,

By doing that the textbox is hiding from that user.

I want to display the text box and user cannot be click on it.

Re: Disable(lock) an object based on user login

ashfaq_haseeb — Mon, 11 Aug 2014 06:03:03 GMT

Hi,

I don't think that can be done.

Regards

ASHFAQ

Re: Disable(lock) an object based on user login

tresB — Mon, 11 Aug 2014 06:05:10 GMT

Well, in that case put a condition in your action, like:

=If(QvUser()<>'UserName', 'SheetID') // for activating sheet action

Do similarly for variable setting action as well.