Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser222
Creator
Creator

Condition on Possible values?

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

Labels (2)
1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

View solution in original post

3 Replies
crusader_
Partner - Specialist
Partner - Specialist

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Partner - Specialist III
Partner - Specialist III

How about the attached?