Facing issue while working on Wildmatch() in QV12

[Anonymous]

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

[marcus_sommer]

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

- Marcus

[swuehl]

Yes, please have a look at the HELP pages:

wildmatch ‒ QlikView

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

[Anonymous]

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.

[Anonymous]

Agreed Stefan n Marcus!!!

Tried but still the same issue.

[marcus_sommer]

For me it worked:

- Marcus

[Anonymous]

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

[marcus_sommer · Accepted solution]

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')

     or

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

- Marcus

[Anonymous]

Thank you very much Marcus!!!!

Will check and revert.

Thank you,

Girish

[Anonymous]

Thank u Marcus!!!!! It worked.