topic Field Event Trigger in QlikView

Field Event Trigger

BarbCline — Thu, 08 Sep 2011 16:34:09 GMT

I have a field event trigger to test the value of a field (OnSelect) and set a variable accordingly. This works great in most scenarios; however, if I have any other field selected, the clearing of the first field does not fire the trigger.

Here's my expression: =if(GetFieldSelections([Case Size]) = '51-99', 'Y', 'N')

When I select or clear Case Size, the trigger fires and sets the variable appropriately. But, if I have any other field selected along with Case Size, when I clear Case Size, the trigger never fires.

Any ideas on how to fix this?

Field Event Trigger

Jason_Michaelides — Thu, 08 Sep 2011 20:16:36 GMT

I think it's because [Case Size] is not actually being selected. Instead of using a trigger and GetFieldSelections([Case Size]) try just creating a variable with the expression =if(Only([Case Size]) = '51-99', 'Y', 'N')

Hope this helps,

Jason

Field Event Trigger

BarbCline — Fri, 09 Sep 2011 14:12:04 GMT

Excellent! That's works perfectly ... and so easy Thanks for sharing, Jason!