topic Re: To Unlock the field by using event field trigger in QlikView

To Unlock the field by using event field trigger

polisetti — Fri, 07 Feb 2014 11:13:52 GMT

Hello,

In my ad-hoc report I have one list box for month selection and one for time period selection.

I wants that on the month selection time period list box should get locked so that user cannot select it.

I have applied the trigger on month selection ->Lock field(Time period).

It is working .On month selection time period is locked.

But I wants that when user will again deselect month then that time period should automatically get unlocked.

Is there any way to resolve this issue???

Thanks in Advance !!!

Re: To Unlock the field by using event field trigger

marcus_sommer — Fri, 07 Feb 2014 12:06:50 GMT

I think this isn't possible - locked is locked and a listbox haven't a click-event. But you could use buttons with appropriate actions.

- Marcus

Re: To Unlock the field by using event field trigger

Anonymous — Fri, 07 Feb 2014 14:53:49 GMT

Actions can be "conditional" - see attached.

Regards,

Michael

Re: To Unlock the field by using event field trigger

Fri, 07 Feb 2014 20:53:45 GMT

Micheal,

Its an interesting feature... can you explain the logic?

Re: To Unlock the field by using event field trigger

Anonymous — Mon, 10 Feb 2014 17:15:42 GMT

Sure.

The trigger is selection in the Month field. Actions:

1. Lock Field, with expression

if(GetSelectedCount(Month)>0,'Period')

That means if at least something is selected in Month, field Period is locked. Otherwise filed to lock is not defined, nothing happens.

2. Unlock Field

if(GetSelectedCount(Month)=0,'Period')

That means if nothing is selected in Month, field Period is unlocked. Otherwise filed to unlock is not defined, nothing happens.

Re: To Unlock the field by using event field trigger

Tue, 11 Feb 2014 03:20:11 GMT

Thank you, Micheal

Re: To Unlock the field by using event field trigger

polisetti — Wed, 12 Feb 2014 04:48:16 GMT

Thanks Michael ,

I will try and i will update wheather it is working in my report.

Re: To Unlock the field by using event field trigger

polisetti — Wed, 12 Feb 2014 15:58:22 GMT

Hi Michael,

I applied the above conditions in my report,when i select on 'month' it is locking the 'time bucket type' and when i unselect the 'Month' it is not working still the 'Time bucket type' is locked .Is there any other way to unlock that field.

Re: To Unlock the field by using event field trigger

Anonymous — Wed, 12 Feb 2014 16:22:54 GMT

If you attach an example, I'll take a look.

Re: Re: To Unlock the field by using event field trigger

polisetti — Wed, 12 Feb 2014 16:53:03 GMT

Hi,

Please try your condition in this sample report..

Re: Re: To Unlock the field by using event field trigger

Anonymous — Wed, 12 Feb 2014 17:01:41 GMT

Your version works fine for me...

What exactly steps should I try to reproduce the issue?

(I'm using 11.20 SR5 64-bit, and tested also in ver 10 SR6)

Re: Re: To Unlock the field by using event field trigger

polisetti — Wed, 12 Feb 2014 17:15:24 GMT

Thanks Michael ,

Its working fine and i need to try it in my Adhoc report .

Re: Re: To Unlock the field by using event field trigger

Wed, 22 Apr 2015 20:44:10 GMT

This was helpful for me as well trying to keep a list box locked even if the user selected Unlock via the menu or through the object properties menu. I was able to make it look like the Unlock was disabled as nothing happened when the user chose it. Thanks.

Re: Re: To Unlock the field by using event field trigger

Wed, 22 Apr 2015 20:59:41 GMT

Here's a simplistic demo.

Re: Re: To Unlock the field by using event field trigger

Mon, 05 Oct 2015 20:25:43 GMT

hi Michael,

I tried to use similar approach but list box 2 (Code) is not getting locked, when list box 1 (Type) is selected, am I missing something here. Please help.

Re: To Unlock the field by using event field trigger

Anonymous — Wed, 14 Oct 2015 22:05:57 GMT

Add another action before "lock" - Select Possible in the field CODE. To execute, "lock" needs something to be selected in this field.