topic Re: Match with contains in QlikView https://community.qlik.com/t5/QlikView/Match-with-contains/m-p/87789#M14314 <HTML><HEAD></HEAD><BODY><P>Thank you!! It's this</P></BODY></HTML> Wed, 05 Sep 2018 17:39:12 GMT breno_morais 2018-09-05T17:39:12Z Match with contains https://community.qlik.com/t5/QlikView/Match-with-contains/m-p/87785#M14310 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have field <STRONG>'Custo_Folha' </STRONG>with values and I need to take this values where '<STRONG>Evento_Folha</STRONG>' contains name <STRONG>"HORAS EXTRAS"</STRONG>, see:</P><P></P><P><IMG alt="Qlik Sense Desktop.jpg" class="jive-image image-1" src="/legacyfs/online/212497_Qlik Sense Desktop.jpg" style="height: auto;" /></P><P></P><P>Any help is appreciated</P></BODY></HTML> Mon, 03 Sep 2018 13:53:05 GMT https://community.qlik.com/t5/QlikView/Match-with-contains/m-p/87785#M14310 breno_morais 2018-09-03T13:53:05Z Re: Match with contains https://community.qlik.com/t5/QlikView/Match-with-contains/m-p/87786#M14311 <HTML><HEAD></HEAD><BODY><P>Looks like you just need WildMatch() - what seems to be the problem?</P></BODY></HTML> Mon, 03 Sep 2018 13:54:03 GMT https://community.qlik.com/t5/QlikView/Match-with-contains/m-p/87786#M14311 Or 2018-09-03T13:54:03Z Re: Match with contains https://community.qlik.com/t5/QlikView/Match-with-contains/m-p/87787#M14312 <HTML><HEAD></HEAD><BODY><P>Where do you need to take those values?</P></BODY></HTML> Mon, 03 Sep 2018 21:16:49 GMT https://community.qlik.com/t5/QlikView/Match-with-contains/m-p/87787#M14312 MarcoWedel 2018-09-03T21:16:49Z Re: Match with contains https://community.qlik.com/t5/QlikView/Match-with-contains/m-p/87788#M14313 <HTML><HEAD></HEAD><BODY><P>Use an aggregation function like Sum() or what is appropriate to 'take the values' with a set expression or an if() statement, something like</P><P></P><P>=Sum(If(Evento_Folha Like '*HORAS EXTRA*', Custa_Folha))</P><P></P><P>or</P><P></P><P>=Sum({&lt;Evento_Folha = {"*HORAS EXTRA*"}&gt;} Custa_Folha)</P></BODY></HTML> Mon, 03 Sep 2018 21:33:40 GMT https://community.qlik.com/t5/QlikView/Match-with-contains/m-p/87788#M14313 swuehl 2018-09-03T21:33:40Z Re: Match with contains https://community.qlik.com/t5/QlikView/Match-with-contains/m-p/87789#M14314 <HTML><HEAD></HEAD><BODY><P>Thank you!! It's this</P></BODY></HTML> Wed, 05 Sep 2018 17:39:12 GMT https://community.qlik.com/t5/QlikView/Match-with-contains/m-p/87789#M14314 breno_morais 2018-09-05T17:39:12Z