Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
How about the attached?