Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

joker problem

I got a problem with a count if

I have a field with 5 digit itemnumbers and want to get all that starts with 7

count(IF(itemnumber='7%%%%' ,................................................

´How do i use a joker like % or * or what is it??

1 Solution

Accepted Solutions

Re: joker problem

count(If(wildmatch(itemnumber,'7*')>0, .....

Let me know

4 Replies

Re: joker problem

count(If(wildmatch(itemnumber,'7*')>0, .....

Let me know

senpradip007
Valued Contributor III

Re: joker problem

Try like:

Count(if(WildMatch(itemnumber, '7*')>0, itemnumber)

mjayachandran
Contributor II

Re: joker problem

You can also

=if(left(itemnumber,1) = 7, itemnumber, null())

MVP
MVP

Re: joker problem

Or, using set analysis to better the performance, like:

=Count({<itemnumber={"7*"}>}intemnumber )

Note: See if you need DISTINCT or not.

Community Browser