topic Re: Check if value is possible in QlikView https://community.qlik.com/t5/QlikView/Check-if-value-is-possible/m-p/619726#M478616 <HTML><HEAD></HEAD><BODY><P>TRy to use wildmatch and concat functions.</P><P></P><P>ex.</P><P>wildmatch(concat(Animals,';'),'Bunny')</P><P></P><P>hope this helps</P><P>Mc</P></BODY></HTML> Mon, 10 Mar 2014 21:16:52 GMT 2014-03-10T21:16:52Z Check if value is possible https://community.qlik.com/t5/QlikView/Check-if-value-is-possible/m-p/619725#M478615 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>conditional calculations: I'd like to check if the value 'Bunny' is possible in the field [Animals], what would the formula look like?</P><P></P><P>Everytime I try to use P in my formulas I get an error (and I've checked the tutorials many times...)</P></BODY></HTML> Mon, 10 Mar 2014 21:05:49 GMT https://community.qlik.com/t5/QlikView/Check-if-value-is-possible/m-p/619725#M478615 sibrulotte 2014-03-10T21:05:49Z Re: Check if value is possible https://community.qlik.com/t5/QlikView/Check-if-value-is-possible/m-p/619726#M478616 <HTML><HEAD></HEAD><BODY><P>TRy to use wildmatch and concat functions.</P><P></P><P>ex.</P><P>wildmatch(concat(Animals,';'),'Bunny')</P><P></P><P>hope this helps</P><P>Mc</P></BODY></HTML> Mon, 10 Mar 2014 21:16:52 GMT https://community.qlik.com/t5/QlikView/Check-if-value-is-possible/m-p/619726#M478616 2014-03-10T21:16:52Z Re: Check if value is possible https://community.qlik.com/t5/QlikView/Check-if-value-is-possible/m-p/619727#M478617 <HTML><HEAD></HEAD><BODY><P>Or...</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.727272033691406px;">max(match(Animals, 'Bunny'))&gt;0</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.727272033691406px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.727272033691406px;">-Rob<BR /></SPAN></P></BODY></HTML> Tue, 11 Mar 2014 00:08:51 GMT https://community.qlik.com/t5/QlikView/Check-if-value-is-possible/m-p/619727#M478617 rwunderlich 2014-03-11T00:08:51Z Re: Check if value is possible https://community.qlik.com/t5/QlikView/Check-if-value-is-possible/m-p/619728#M478618 <HTML><HEAD></HEAD><BODY><P>or...</P><P>index(concat(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Animals</SPAN>),<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> 'Bunny'))&gt;0</SPAN></P></BODY></HTML> Tue, 11 Mar 2014 01:36:58 GMT https://community.qlik.com/t5/QlikView/Check-if-value-is-possible/m-p/619728#M478618 Clever_Anjos 2014-03-11T01:36:58Z Re: Check if value is possible https://community.qlik.com/t5/QlikView/Check-if-value-is-possible/m-p/619729#M478619 <HTML><HEAD></HEAD><BODY><P>in calcualtion condition write</P><P>Fieldname='Bunny'</P><P>or </P><P>wildmatch(Fieldname,'Bunny')</P></BODY></HTML> Tue, 11 Mar 2014 04:46:25 GMT https://community.qlik.com/t5/QlikView/Check-if-value-is-possible/m-p/619729#M478619 er_mohit 2014-03-11T04:46:25Z