topic Re: Multiple Box in QlikView https://community.qlik.com/t5/QlikView/Multiple-Box/m-p/999739#M339912 <HTML><HEAD></HEAD><BODY><P>Perhaps if you tried using WildMatch() it wouldn't look for JUST the one selection, but whether it was selected at all?</P></BODY></HTML> Fri, 16 Oct 2015 20:23:59 GMT crystles 2015-10-16T20:23:59Z Multiple Box https://community.qlik.com/t5/QlikView/Multiple-Box/m-p/999738#M339911 <HTML><HEAD></HEAD><BODY><P>I have a multiple selection box.</P><P></P><P>Cars:</P><P>LOAD * Inline [</P><P>CARS</P><P>Ferrari</P><P>Porsche</P><P>Rolls Royce</P><P>Suzuki</P><P>];</P><P></P><P>Now i am looking for a formula </P><P>If i have selected in the cars the value Ferrari then i want to show a specific column</P><P>I have next formula</P><P>If((Match(CARS,'Ferrari') = 1),1,0)</P><P></P><P>but it doesn't work if i have selected ferrari and porsche at the same time.</P><P></P><P>does anyone know?</P></BODY></HTML> Fri, 16 Oct 2015 20:21:54 GMT https://community.qlik.com/t5/QlikView/Multiple-Box/m-p/999738#M339911 2015-10-16T20:21:54Z Re: Multiple Box https://community.qlik.com/t5/QlikView/Multiple-Box/m-p/999739#M339912 <HTML><HEAD></HEAD><BODY><P>Perhaps if you tried using WildMatch() it wouldn't look for JUST the one selection, but whether it was selected at all?</P></BODY></HTML> Fri, 16 Oct 2015 20:23:59 GMT https://community.qlik.com/t5/QlikView/Multiple-Box/m-p/999739#M339912 crystles 2015-10-16T20:23:59Z Re: Multiple Box https://community.qlik.com/t5/QlikView/Multiple-Box/m-p/999740#M339913 <HTML><HEAD></HEAD><BODY><P>Try this formula:</P><P></P><P>alt(WildMatch(GetFieldSelections(CARS,'|'),'*Ferrari*'),0)</P></BODY></HTML> Fri, 16 Oct 2015 20:28:01 GMT https://community.qlik.com/t5/QlikView/Multiple-Box/m-p/999740#M339913 2015-10-16T20:28:01Z