topic Field Event Trigger, Action in QlikView https://community.qlik.com/t5/QlikView/Field-Event-Trigger-Action/m-p/178640#M501538 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I'm trying to use field event triggers to deselect fields based on the value of another field.</P><P>It's not working, tho.</P><P>Needed Logic: When the UpSegment field is selected, if the only selection is 'K12' then clear the Col_Rep field</P><P>On Select, UpSegment, Select in field, Col_Rep</P><P>The search string looks like this:</P><P>=If(only(UpSegment) = 'K12','', ????? )</P><P>what should the else look like (preventing any selection change)? am i doing this right ?</P><P>Would it be better to do it with a Macro ? Can someone please provide a macro example for this ?</P><P>Thank you in advance !</P><P>Tim</P></BODY></HTML> Tue, 09 Nov 2010 17:15:37 GMT 2010-11-09T17:15:37Z Field Event Trigger, Action https://community.qlik.com/t5/QlikView/Field-Event-Trigger-Action/m-p/178640#M501538 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I'm trying to use field event triggers to deselect fields based on the value of another field.</P><P>It's not working, tho.</P><P>Needed Logic: When the UpSegment field is selected, if the only selection is 'K12' then clear the Col_Rep field</P><P>On Select, UpSegment, Select in field, Col_Rep</P><P>The search string looks like this:</P><P>=If(only(UpSegment) = 'K12','', ????? )</P><P>what should the else look like (preventing any selection change)? am i doing this right ?</P><P>Would it be better to do it with a Macro ? Can someone please provide a macro example for this ?</P><P>Thank you in advance !</P><P>Tim</P></BODY></HTML> Tue, 09 Nov 2010 17:15:37 GMT https://community.qlik.com/t5/QlikView/Field-Event-Trigger-Action/m-p/178640#M501538 2010-11-09T17:15:37Z