topic Re: joker problem in QlikView https://community.qlik.com/t5/QlikView/joker-problem/m-p/678236#M669318 <HTML><HEAD></HEAD><BODY><P>Or, using set analysis to better the performance, like:</P><P>=Count({&lt;itemnumber={"7*"}&gt;}intemnumber )</P><P></P><P>Note: See if you need DISTINCT or not.</P></BODY></HTML> Wed, 08 Oct 2014 07:15:13 GMT tresB 2014-10-08T07:15:13Z joker problem https://community.qlik.com/t5/QlikView/joker-problem/m-p/678232#M669314 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #ff8000; font-size: 8pt;">I got a problem with a count if</SPAN></P><P><SPAN style="color: #ff8000; font-size: 8pt;">I have a field with 5 digit itemnumbers and want to get all that starts with 7</SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">IF</SPAN><SPAN style="font-size: 8pt;">(itemnumber</SPAN><SPAN style="font-size: 8pt;">='7%%%%' ,................................................</SPAN></P><P> </P><P><SPAN style="font-size: 8pt;">´How do i use a joker like % or * or what is it??</SPAN></P><P></P></BODY></HTML> Wed, 08 Oct 2014 06:57:51 GMT https://community.qlik.com/t5/QlikView/joker-problem/m-p/678232#M669314 2014-10-08T06:57:51Z Re: joker problem https://community.qlik.com/t5/QlikView/joker-problem/m-p/678233#M669315 <HTML><HEAD></HEAD><BODY><P>count(If(wildmatch(itemnumber,'7*')&gt;0, .....</P><P></P><P></P><P>Let me know</P></BODY></HTML> Wed, 08 Oct 2014 06:59:41 GMT https://community.qlik.com/t5/QlikView/joker-problem/m-p/678233#M669315 alexandros17 2014-10-08T06:59:41Z Re: joker problem https://community.qlik.com/t5/QlikView/joker-problem/m-p/678234#M669316 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P>Count(if(WildMatch(itemnumber, '7*')&gt;0, itemnumber)</P></BODY></HTML> Wed, 08 Oct 2014 07:00:19 GMT https://community.qlik.com/t5/QlikView/joker-problem/m-p/678234#M669316 senpradip007 2014-10-08T07:00:19Z Re: joker problem https://community.qlik.com/t5/QlikView/joker-problem/m-p/678235#M669317 <HTML><HEAD></HEAD><BODY><P>You can also</P><P></P><P>=if(left(itemnumber,1) = 7, itemnumber, null())</P></BODY></HTML> Wed, 08 Oct 2014 07:09:58 GMT https://community.qlik.com/t5/QlikView/joker-problem/m-p/678235#M669317 mjayachandran 2014-10-08T07:09:58Z Re: joker problem https://community.qlik.com/t5/QlikView/joker-problem/m-p/678236#M669318 <HTML><HEAD></HEAD><BODY><P>Or, using set analysis to better the performance, like:</P><P>=Count({&lt;itemnumber={"7*"}&gt;}intemnumber )</P><P></P><P>Note: See if you need DISTINCT or not.</P></BODY></HTML> Wed, 08 Oct 2014 07:15:13 GMT https://community.qlik.com/t5/QlikView/joker-problem/m-p/678236#M669318 tresB 2014-10-08T07:15:13Z