Condition on Possible values?

[qlikuser222]

Hi All,

I have a requirement where i want to use a condition to show hide text box base  on possible value.

PFA which has detailed example set of my condition.

Thanks

[crusader_]

Hi,

Try below expresssions:

=IF(WILDMATCH(CONCAT(Code,'|'),'*AAA*'), 'Yes','No')

and

=IF(WILDMATCH(CONCAT(Code,'|'),'*AAA*','*DDD*'), 'Yes','No')

PFA example.

Hope this helps.

//Andrei

[rwunderlich · Accepted solution]

To test if a value exists in a field's possible values use:

max(match(field, 'value'))

=if(max(match(Code,'AAA')), 'Yes','No')

And to test multiple values, as an OR: 

=if(max(match(Code,'AAA', 'DDD')), 'Yes','No')

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[hopkinsc]

How about the attached?