topic Re: Wildmatch, Wildmatch5 & LIKE function in QlikView

Wildmatch, Wildmatch5 & LIKE function

Fri, 13 Sep 2013 07:13:48 GMT

I want to tag a list of account with below query:

if(WildMatch([MAKE & MODEL],'*MOTORC*'),'Motorcycle',

if(REASON_CODE='SKIP','Exclusion List',

if([PRODUCT TYPE]='902' or [PRODUCT TYPE]='903','Floor Stocking',

if([PRODUCT TYPE]='900' or [PRODUCT TYPE]='901',Block Discounting',

if([DISBURSEMENT YEAR]=2013 AND RNR='N' AND [CUSTOMER TYPE]='I','MPR_13'

if([CUSTOMER TYPE]='C' or [CUSTOMER TYPE]='N' or [CUSTOMER TYPE]='S','Company,'Others')))))) as CATEGORIES,

Other than 'Motorcycle', was tag accordingly. I've use WildMatch & LIKE but still none of the account was tagged with it.

But if I run only 'Motorcyle' condition without others, system can tagged it accordingly.

Anybody have better idea to solve this query?

Re: Wildmatch, Wildmatch5 & LIKE function

tresB — Fri, 13 Sep 2013 07:21:16 GMT

Without a data sample it would be very hard. Please post sample app with a small data.

Re: Wildmatch, Wildmatch5 & LIKE function

Fri, 13 Sep 2013 08:28:27 GMT

I have attached the before tag & after tag in the excel file attached.

Re: Re: Wildmatch, Wildmatch5 & LIKE function

tresB — Fri, 13 Sep 2013 08:45:05 GMT

PFA

Re: Wildmatch, Wildmatch5 & LIKE function

Fri, 13 Sep 2013 09:21:59 GMT

You can use it like this :

if(WildMatch([MAKE & MODEL],'*MOTORC*'),'Motorcycle',

if([REASON CODE]='SKIP','Exclusion List',

if([PRODUCT TYPE]='902' or [PRODUCT TYPE]='903','Floor Stocking',

if([PRODUCT TYPE]='900' or [PRODUCT TYPE]='901','Block Discounting',

if([DISBURSEMENT YEAR]=2013 AND [CUSTOMER TYPE]='I','MPR_13',

if([CUSTOMER TYPE]='C' or [CUSTOMER TYPE]='N' or [CUSTOMER TYPE]='S','Company','Others')
))))) as CATEGORIES

Re: Wildmatch, Wildmatch5 & LIKE function

Tue, 17 Sep 2013 03:10:08 GMT

Have test it & its successfully tagged.

If the field provided previously were in different table, it was understood that I have join it, can the same query be used? Caused that was the real headache actually.

Re: Wildmatch, Wildmatch5 & LIKE function

Tue, 17 Sep 2013 04:09:31 GMT

Thanks for the assistance.