Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Field Event Trigger, Action


I'm trying to use field event triggers to deselect fields based on the value of another field.

It's not working, tho.

Needed Logic: When the UpSegment field is selected, if the only selection is 'K12' then clear the Col_Rep field

On Select, UpSegment, Select in field, Col_Rep

The search string looks like this:

=If(only(UpSegment) = 'K12','', ????? )

what should the else look like (preventing any selection change)? am i doing this right ?

Would it be better to do it with a Macro ? Can someone please provide a macro example for this ?

Thank you in advance !