topic Re: Wildcard and match issue in QlikView

Wildcard and match issue

helen_pip — Tue, 02 Apr 2013 13:11:19 GMT

Hello

I have an issue with trying to use the widcard and match functions

I would like to see where all comments start with *T or *D however the field I am actually using is actually '*T' and '*D' and a widcard also starts with a *

How would I write this

I.e. If(MATCH(comments, * '*T', * '*D',1,0)

Thanks

Helen

Re: Wildcard and match issue

kaushiknsolanki — Tue, 02 Apr 2013 13:16:20 GMT

Hi,

Try wildmatch instead of match.

Regards,

Kaushik Solanki

Re: Wildcard and match issue

helen_pip — Tue, 02 Apr 2013 13:21:04 GMT

Thanks for your reply

Could you kindly help me write this?

When the comments field starts with a *T or a *D then I would like to put a flag of 1 next to each comment

Any help is greatly appreciated

Thanks

Helen

Re: Wildcard and match issue

kaushiknsolanki — Tue, 02 Apr 2013 13:25:17 GMT

Hi,

Your expresison will be.

If(WILDMATCH(comments, '*T', '*D'),1,0)

Regards,

Kaushik Solanki

Re: Wildcard and match issue

helen_pip — Tue, 02 Apr 2013 13:35:25 GMT

Hello

Thanks for your help and you ahve helped me undertsand the syntex, however as the widcard starts with a * and my comment field search also starts with a * I.e. a comment will be *T 0812305860

The syntex is getting confused with where I want to start seraching as it is also picking up

1801028 T 0025888

Yet I require where the comments always start with *T (Actual start of comments field)

Thanks for your help

Re: Wildcard and match issue

helen_pip — Tue, 02 Apr 2013 13:44:59 GMT

Hello

I have managed to use the replace function to compensate for the fact that my comments field starts with a *

I.e.

IF(WILDMATCH(Replace(comments, '*','!'),'!D*'), 1) AS TEST

Thanks for all your help

Helen