topic Re: Condition on Possible values? in QlikView

Condition on Possible values?

qlikuser222 — Sat, 16 Nov 2024 04:15:54 GMT

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_ — Tue, 05 Mar 2019 23:36:02 GMT

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 — Tue, 05 Mar 2019 23:43:27 GMT

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')

hopkinsc — Tue, 05 Mar 2019 23:53:45 GMT

How about the attached?