topic Re: Locked field and field trigger in QlikView

Locked field and field trigger

Thu, 08 Sep 2011 09:57:51 GMT

Hi,

here is my problem:

I have a field that is locked with the trigger OnLeaveSheet. In the same time, I want that as soon as I make a selection in the field, the next sheet is automatically opened. I do this with the Field Event Trigger, OnSelect and my field. But the Trigger OnSelect totally delete the effect of the first trigger, that's to say that my field is not locked anymore.

If you have any option. Thanks in advance.

Locked field and field trigger

Thu, 08 Sep 2011 10:03:14 GMT

Hi,

Are you able to put up an example to work with, would make it easier to see what's going wrong

thanks

Joe

Re: Locked field and field trigger

Fri, 09 Sep 2011 07:49:53 GMT

Here is an example, build with the tutorial sheets.

You can see that once selected, the country field should be locked and no change are supposed to be possible on sheet 2. But if you click on the pie chart, the selection is changed, so the field country is not locked anymore.

Re: Locked field and field trigger

Fri, 09 Sep 2011 08:29:29 GMT

you just need to add 'lock field' to your event actions on the country field,

have a look at attached, is that what you mean?

thanks

Joe

Re: Locked field and field trigger

Fri, 09 Sep 2011 08:48:41 GMT

Thanks, it already helps.

But now if I unselect a country in the first sheet, I don't want to activate the second sheet. In fact, I would like the Country field selection to be possible only on the first sheet. And the second sheet sould be activated only if one country is selected.

Re: Locked field and field trigger

Fri, 09 Sep 2011 08:53:29 GMT

Well, and actually in my real document, I'm using a hierarchy, so once I selected something in the descendant field, the field country is unlocked, especially if what I selected in the descendance is available in 2 different countries.

So I already tried it but in my case, the trigger Lock OnSelect is not really working.

Re: Locked field and field trigger

Fri, 09 Sep 2011 09:03:35 GMT

so you mean when you make a selection further down your hierarchy you want your country field to lock also?

i've attached a fix for the clearing problem also

thanks

Joe

Re: Locked field and field trigger

Fri, 09 Sep 2011 09:06:48 GMT

Ok up to this it is perfect.

If I go further down in my hierarchy, I want the country field to remain locked, since it was locked on sheet1.

Re: Locked field and field trigger

Fri, 09 Sep 2011 09:08:27 GMT

Thanks, the macro is simple but very useful.

Re: Locked field and field trigger

Fri, 09 Sep 2011 09:37:01 GMT

Hi Joe,

just a little question. When I use your macro, adapted to my doc, the sheet activation wouldn't work. I created the variable, put the right field name and sheetID, everything works but the activateSheet.

Do you have any idea?

Re: Locked field and field trigger

Fri, 09 Sep 2011 09:45:57 GMT

you'll need to call the macro in your trigger to get it to run,

also by locking the country field you will only be able to make possible selections further down your hierarchy, not sure what you mean by this, is your app unlocking country when you select further down the hierarchy?

Re: Locked field and field trigger

Fri, 09 Sep 2011 11:13:01 GMT

For the use of the macro, that's what i'm doing but for a reason i ignore, the sheet wouldn't activate. Anyway, that's not such a big deal. For the hierarchy, that is working well with your macro, but yes, in my intial problem, it was unlocking the country if i selected something further down in the hierarchy, especially if a city was present in two countries, it would unlock and select both countries.

Re: Locked field and field trigger

Fri, 09 Sep 2011 12:31:44 GMT

Ok, it works perfect. I just forgot or wrongly define the variable countryCount.

Thanks a lot Joe.