topic Re: Rewrite Expression. in QlikView

Rewrite Expression.

Fri, 29 Nov 2013 06:55:58 GMT

Hi,

I have expression below

if(status=amber,yellow,

if(status=red,red,

if(ststus=green,green)))

i just want to rewrite this expression using match() or any other function just to avoid multiple if condition. please advice.

Regards,

Piyush

Re: Rewrite Expression.

tresB — Fri, 29 Nov 2013 07:00:52 GMT

Pick( Match(status, 'amber', 'red', 'green') , 'yellow', 'red' , 'green')

Or,

If( status='amber', 'yellow' , status)

Re: Rewrite Expression.

Fri, 29 Nov 2013 07:26:57 GMT

Thanks Tresesco. i just want to know that pick expression really increases performance over multiple if conditions.

Regards,

Piyush

Re: Rewrite Expression.

tresB — Fri, 29 Nov 2013 07:32:18 GMT

Yes, pick-match combination is performance wise better than multiple IFs.

Re: Rewrite Expression.

Fri, 29 Nov 2013 07:47:19 GMT

Thanks for this valuable information.

Re: Rewrite Expression.

Fri, 29 Nov 2013 09:57:16 GMT

Hi tresesco,

Didn't get second expression if(status='Amber',yellow,status). could you please explain.

Regards,

Piyush.

Re: Rewrite Expression.

Wed, 11 Dec 2013 12:05:57 GMT

Hi Tresesco,

In the above expression as if(status=amber,amber,if(stautus=red,red,if(status=green,green))) but if want to insert else condition in it , then how will we deal with that in pick(match) function.

Regards

Piyush