topic Re: Alternate to Nested if condition in QlikView

Alternate to Nested if condition

sridhar_sigired — Wed, 18 Nov 2015 09:05:59 GMT

Hi,

I have nested if condition something like below (too nested).

IF (A like 'AZK*' , 'Azzar',

IF (A like 'VDN*' , 'Vodapone',

IF (A like 'WB*' , 'WorldBlue',

IF (A like 'wow*' , 'WOW! Security',

IF (A like 'ZA*' , 'ZoneAlarm',

IF (A like 'ys*' , 'sdgrsw',

'Unknown')))))

Can i use Match or any other function to avoid this nested IF??? for better performance?

Regards,

Sridhar

Re: Alternate to Nested if condition

sunny_talwar — Wed, 18 Nov 2015 09:10:19 GMT

Try this:

Pick(WildMatch(A, 'AZK*', 'VDN*', 'WB*', 'wow*', 'ZA*', 'ys*', A), 'Azzar', 'Vodapone', 'WorldBlue', 'WOW! Security', 'ZoneAlarm', 'sdgrsw', 'Unknown')

Re: Alternate to Nested if condition

tresB — Wed, 18 Nov 2015 09:10:32 GMT

Pick(WildMatch(A ,'AZK*' , 'VDN*','WB*','wow*','ZA*', 'ys*')+1, 'Unknown', 'Azzar', 'Vodapone','WorldBlue','WOW! Security', 'ZoneAlarm','sdgrsw')

Re: Alternate to Nested if condition

sridhar_sigired — Wed, 18 Nov 2015 09:11:51 GMT

May i know why we have used +1 here?

Re: Alternate to Nested if condition

tresB — Wed, 18 Nov 2015 09:16:12 GMT

If there would be no match, wildmatch() would return 0, otherwise it's match index . By adding 1 to 0, pick() is told to pick the 1st text, i.e- 'Unknown'. For rest of the matched values, position is deferred by 1. Hope this helps.

Re: Alternate to Nested if condition

sridhar_sigired — Wed, 18 Nov 2015 09:16:30 GMT

Hi Sunny,

Unknown used here as for if not else, not to replace as 'A'. Can you clear the confusion?

Re: Alternate to Nested if condition

sunny_talwar — Wed, 18 Nov 2015 09:18:13 GMT

In the new field that will be created you want it to be called 'Unknown', if it doesn't match any other names that we listed within WildMatch()?

Re: Alternate to Nested if condition

sridhar_sigired — Wed, 18 Nov 2015 09:23:54 GMT

OK Let me try yours and from tresesco. And take the one which is working. Thank you.