topic wildmatch in expression in QlikView

wildmatch in expression

capriconuser — Wed, 25 Nov 2020 16:16:04 GMT

i have this expression

count(if(wildmatch(sm_no,'US*'),left(sm_no,9),amount_lc))

in that condition i am trying to get the sm_no who start with US and extract first 9 digits

further more i want to add another condition that code =947 so how i add into this

is this expression is correct?

Re: wildmatch in expression

Shubham_Deshmukh — Tue, 26 Mar 2019 09:34:51 GMT

You want first 9 digits after that condition or you want count also ? bcoz requirement looks confusing.
Please clear.

Re: wildmatch in expression

capriconuser — Tue, 26 Mar 2019 09:38:16 GMT

i want first 9 digits of sm_no and that sm_no should start with US and want count also

Re: wildmatch in expression

Shubham_Deshmukh — Tue, 26 Mar 2019 09:38:36 GMT

Then why you are taking count of amount_lc?

Re: wildmatch in expression

capriconuser — Tue, 26 Mar 2019 09:41:57 GMT

beacuse i need count of amount_lc bases on these conditions which i mentioned above

Re: wildmatch in expression

Shubham_Deshmukh — Tue, 26 Mar 2019 09:45:59 GMT

That's what I am saying, you want 9 characters starting with US or count ?
Because for getting a count you only need yo use condition of wildmatch() and code =947.
How would we do by using left(sm_no,9) ? it will not act as condition.

Re: wildmatch in expression

capriconuser — Tue, 26 Mar 2019 09:48:11 GMT

i want both ,, so how i apply that left condition in set analysis?

Re: wildmatch in expression

Shubham_Deshmukh — Tue, 26 Mar 2019 09:50:52 GMT

You can use this for getting count,
=Count(if(WildMatch(sm_no,'US*') and code=66,amount_lc))
For count, you can get count OR you can get those 9 char starts with US.

Suppose, you want count of sm_no starting with US(9 char) as per your question, but it will also give same result as it will also contain US.

Re: wildmatch in expression

capriconuser — Tue, 26 Mar 2019 10:03:56 GMT

this is not working secondly i want to first 9 digits because there is some inappropriate text in sm_no like this
US0010191KJDKLSAJDJ
US0010191ERKJLEWR
so that why i only want to get first 9 digitis

Re: wildmatch in expression

Shubham_Deshmukh — Tue, 26 Mar 2019 10:06:22 GMT

You said you also want count

Re: wildmatch in expression

capriconuser — Tue, 26 Mar 2019 11:02:01 GMT

yes but this is not working which you mentioned expression