topic Re: Facing issue while working on Wildmatch() in QV12 in QlikView

Facing issue while working on Wildmatch() in QV12

Anonymous — Mon, 28 Nov 2016 12:52:34 GMT

Hey guys,

Needed help on Wildmatch().

Sample data

Description
MY WALLET - CASHBACK - NU27011981410574
MY WALLET - CASHBACK - NU77010981580515
MY WALLET - CASHBACK - NU77010981592963
BURN

I want to tag against those descriptions where it contains MY WALLET.

Code :- if(Wildmatch(Description,'%MY WALLET%'),'Yes','No')

But its not working its returning No.

Please help.

Thank you in advance,

Girish

Re: Facing issue while working on Wildmatch() in QV12

marcus_sommer — Mon, 28 Nov 2016 12:55:38 GMT

Try: if(Wildmatch(Description,'*MY WALLET*'),'Yes','No')

- Marcus

Re: Facing issue while working on Wildmatch() in QV12

swuehl — Mon, 28 Nov 2016 12:57:58 GMT

Yes, please have a look at the HELP pages:

wildmatch ‒ QlikView

"It permits the use of wildcard characters ( * and ?) in the comparison strings. "

Re: Facing issue while working on Wildmatch() in QV12

Anonymous — Mon, 28 Nov 2016 13:41:45 GMT

Thank you guys for the prompt reply!

Would like to correct the code

Wildmatch(Description,'*MY WALLET*')

But still it's not working.

Inspire of above code even I tried using replace function to replace MY WALLET string to MY_WALLET and in that MY_WALLET string I tried using wildmatch but still the same result.

I know replace is not required in this case but still tried working out but no proper result.

Re: Facing issue while working on Wildmatch() in QV12

Anonymous — Mon, 28 Nov 2016 13:44:02 GMT

Agreed Stefan n Marcus!!!

Tried but still the same issue.

Re: Facing issue while working on Wildmatch() in QV12

marcus_sommer — Mon, 28 Nov 2016 13:48:28 GMT

For me it worked:

- Marcus

Re: Facing issue while working on Wildmatch() in QV12

Anonymous — Mon, 28 Nov 2016 13:52:07 GMT

Hey Marcus,

Yup this same is working on text object.

But when it's applied in the script level it's not worked.

Even I can't understand.

Thank you,

Girish

Re: Facing issue while working on Wildmatch() in QV12

marcus_sommer — Mon, 28 Nov 2016 14:02:50 GMT

I think you need to check which chars your data really contain - quite useful is in such cases an editor like notepad++.

Another try for testing could be:

if(Wildmatch(Description,'*MY*WALLET*'),'Yes','No')

if(Wildmatch(Description,'*MY*','*WALLET*'),'Yes','No')

- Marcus

Re: Facing issue while working on Wildmatch() in QV12

Anonymous — Mon, 28 Nov 2016 14:07:17 GMT

Thank you very much Marcus!!!!

Will check and revert.

Thank you,

Girish

Re: Facing issue while working on Wildmatch() in QV12

Anonymous — Tue, 29 Nov 2016 07:33:56 GMT

Thank u Marcus!!!!! It worked.