topic Parse data with condition in QlikView https://community.qlik.com/t5/QlikView/Parse-data-with-condition/m-p/338989#M1171712 <HTML><HEAD></HEAD><BODY><P>You should be able to use 'like'.</P><P></P><P>Variable = If([Fieldname] like '*# of locations*','True','False')</P><P></P><P>good luck!</P><P><SPAN style="color: #0000ff; font-size: 8pt;"> </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"> </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"> </SPAN></P></BODY></HTML> Tue, 05 Jun 2012 22:34:31 GMT 2012-06-05T22:34:31Z Parse data with condition https://community.qlik.com/t5/QlikView/Parse-data-with-condition/m-p/338987#M1171710 <HTML><HEAD></HEAD><BODY><P>How do you set a variable from a condition statement. If field A contains the words '# of locations' then set field B to TRUE.</P></BODY></HTML> Tue, 05 Jun 2012 21:13:44 GMT https://community.qlik.com/t5/QlikView/Parse-data-with-condition/m-p/338987#M1171710 2012-06-05T21:13:44Z Parse data with condition https://community.qlik.com/t5/QlikView/Parse-data-with-condition/m-p/338988#M1171711 <HTML><HEAD></HEAD><BODY><P>I dont know if I understand well but as can see you can create the 2 variables with the next statement: </P><P>Variable1 =if([FIELDNAME]=2009,1,0)</P><P>Variable2 =if($(Variable1)=1,'TRUE','FALSE')</P><P></P><P>You can make a force selection of a field with the information of the variable that you want I meant you can create a button or something to activate a selection depends on the variables that you created.</P><P></P><P>Hoe it helps.</P></BODY></HTML> Tue, 05 Jun 2012 22:06:27 GMT https://community.qlik.com/t5/QlikView/Parse-data-with-condition/m-p/338988#M1171711 2012-06-05T22:06:27Z Parse data with condition https://community.qlik.com/t5/QlikView/Parse-data-with-condition/m-p/338989#M1171712 <HTML><HEAD></HEAD><BODY><P>You should be able to use 'like'.</P><P></P><P>Variable = If([Fieldname] like '*# of locations*','True','False')</P><P></P><P>good luck!</P><P><SPAN style="color: #0000ff; font-size: 8pt;"> </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"> </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"> </SPAN></P></BODY></HTML> Tue, 05 Jun 2012 22:34:31 GMT https://community.qlik.com/t5/QlikView/Parse-data-with-condition/m-p/338989#M1171712 2012-06-05T22:34:31Z