topic Re: HOW TO USE IF & WILDMATCH TOGETHER ? in QlikView

HOW TO USE IF & WILDMATCH TOGETHER ?

Sat, 23 Mar 2013 04:18:44 GMT

Hi All,

I have a filed "A" with some 100 values.

I have to assign some group to a particular value and rest of it should be in "NA" group.

The code used is :-

if(wildmatch(A),'*Sarang*'),Group 1,

if(wildmatch(A),'*Nitika*),Group2,))

Now i want the rest of the values to be shown in "NA"..... how do i do it?

I tried :-

if(wildmatch(A),'*Sarang*'),'Group 1',

if(wildmatch(A),'*Nitika*),'Group2','NA'))

if(wildmatch(A),'*Sarang*'),'Group 1','NA'

if(wildmatch(A),'*Nitika*),'Group2','NA'))

IT DOES NOT WORK.

Please help

Re: HOW TO USE IF & WILDMATCH TOGETHER ?

somenathroy — Sat, 23 Mar 2013 04:35:47 GMT

Hi,

The below statement should works :

if(WildMatch(A,'*Sarang*'),'Group 1',

if(WildMatch(A,'*Nitika*'),'Group 2','NA')

) as Group

I think it's a opening and closing parenthesis problem.

Regards,

som

Re: HOW TO USE IF & WILDMATCH TOGETHER ?

Sat, 23 Mar 2013 05:10:00 GMT

Hi,

I am able to assign values to Group 1 & group 2.

But I am unable to assign the remaining values to "NA".

PLEASE HELP

Re: HOW TO USE IF & WILDMATCH TOGETHER ?

sushil353 — Sat, 23 Mar 2013 05:26:32 GMT

Please post the sample application..

I could not find any issue in

if(WildMatch(A,'*Sarang*'),'Group 1',

if(WildMatch(A,'*Nitika*'),'Group 2','NA')

) as Group

HTH

Sushil

Re: HOW TO USE IF & WILDMATCH TOGETHER ?

er_mohit — Sat, 23 Mar 2013 06:58:27 GMT

if(wildMATCH5(A,'*Sarang*'),'Group 1',

if(wildMATCH5(A,'*Nitika*'),'Group 2','NA')) as Group

Re: HOW TO USE IF & WILDMATCH TOGETHER ?

jeffmartins — Tue, 26 Mar 2013 02:47:17 GMT

Hi sarangmehta,

This should works:

pick( 1+wildmatch(A,'*Sarang*','*Nitika*'),

'NA', 'Group 1', 'Group 2') as Group

Hope this helps you.

Regards

Re: HOW TO USE IF & WILDMATCH TOGETHER ?

Wed, 03 Apr 2013 10:53:41 GMT

Hi Jeff,

Tried ur solution but dsnt work.

The data type is huge clob at database level. The data consists of different names in upper /lower case as well as 1-2 page of mails.

so we are using wildmatch and '*SARANG*' to get the required result.

Also there may be a possibility that value = 'SARANG' may be present in mails also.

So i want to assign values that consits of only 'SARANG' in group 1 and rest of the emails in 'NA'.

Appreciate your help.

Re: HOW TO USE IF & WILDMATCH TOGETHER ?

kaushiknsolanki — Wed, 03 Apr 2013 12:04:42 GMT

Hi,

Is it possible for you to post some example.

Regards,

Kaushik Solanki

Re: HOW TO USE IF & WILDMATCH TOGETHER ?

jeffmartins — Wed, 03 Apr 2013 12:18:13 GMT

Hi sarangmehta,

In this case you should try the match() function instead of the wildmatch().

pick( 1+match(A,'Sarang','Nitika'),

'NA', 'Group 1', 'Group 2') as Group

Hope this helps you.

Regards