topic Re: using variables in a wildcard countif in QlikView https://community.qlik.com/t5/QlikView/using-variables-in-a-wildcard-countif/m-p/658251#M240199 <HTML><HEAD></HEAD><BODY><P>sorry I tried it in the back end and it worked perfectly thanks so much&nbsp; !</P></BODY></HTML> Fri, 11 Jul 2014 08:31:55 GMT 2014-07-11T08:31:55Z using variables in a wildcard countif https://community.qlik.com/t5/QlikView/using-variables-in-a-wildcard-countif/m-p/658247#M240195 <HTML><HEAD></HEAD><BODY><P>Hiya Im quite new to qlikview and wondering if anyone can help me</P><P></P><P>I have a field called leasing co with multiple company codes within it i was looking to count the rows which contain a particular company os for eg how many instances in the column that contain 'vLeasingCo'.</P><P></P><P>Any help greatly appreciated <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> </P></BODY></HTML> Fri, 11 Jul 2014 08:06:51 GMT https://community.qlik.com/t5/QlikView/using-variables-in-a-wildcard-countif/m-p/658247#M240195 2014-07-11T08:06:51Z Re: using variables in a wildcard countif https://community.qlik.com/t5/QlikView/using-variables-in-a-wildcard-countif/m-p/658248#M240196 <HTML><HEAD></HEAD><BODY><P>Use WildMatch() rather than if. Try like:</P><P></P><P>=Count( WildMatch(YourField, '*' &amp; '$(vLeasingCo)' &amp;'*'), YourField)</P></BODY></HTML> Fri, 11 Jul 2014 08:17:10 GMT https://community.qlik.com/t5/QlikView/using-variables-in-a-wildcard-countif/m-p/658248#M240196 tresB 2014-07-11T08:17:10Z Re: using variables in a wildcard countif https://community.qlik.com/t5/QlikView/using-variables-in-a-wildcard-countif/m-p/658249#M240197 <HTML><HEAD></HEAD><BODY><P>Hi tresesco,</P><P></P><P>It looked perfect but didn't work <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /> told me I could only have 1 parameter for a count </P></BODY></HTML> Fri, 11 Jul 2014 08:23:13 GMT https://community.qlik.com/t5/QlikView/using-variables-in-a-wildcard-countif/m-p/658249#M240197 2014-07-11T08:23:13Z Re: using variables in a wildcard countif https://community.qlik.com/t5/QlikView/using-variables-in-a-wildcard-countif/m-p/658250#M240198 <HTML><HEAD></HEAD><BODY><P>count({$&lt;YourField={"*vLeasingCo*"} YourField)</P></BODY></HTML> Fri, 11 Jul 2014 08:30:22 GMT https://community.qlik.com/t5/QlikView/using-variables-in-a-wildcard-countif/m-p/658250#M240198 simondachstr 2014-07-11T08:30:22Z Re: using variables in a wildcard countif https://community.qlik.com/t5/QlikView/using-variables-in-a-wildcard-countif/m-p/658251#M240199 <HTML><HEAD></HEAD><BODY><P>sorry I tried it in the back end and it worked perfectly thanks so much&nbsp; !</P></BODY></HTML> Fri, 11 Jul 2014 08:31:55 GMT https://community.qlik.com/t5/QlikView/using-variables-in-a-wildcard-countif/m-p/658251#M240199 2014-07-11T08:31:55Z