topic Re: Else condition in pick match. in QlikView

Else condition in pick match.

Thu, 19 Dec 2013 10:30:10 GMT

Hi,

i have expression like if(status=A,green,

if(status=B,Amber,

if(status=C,Red,Grey))).

How can we rewrite this Expression using Pick(Match) function for else condition also.

Regards,

Piyush Jain

Re: Else condition in pick match.

Gysbert_Wassenaar — Thu, 19 Dec 2013 10:32:50 GMT

pick(match(status, 'A', 'B', 'C')+1, 'Grey', 'green', 'Amber', 'Red')

Re: Else condition in pick match.

VishalWaghole — Thu, 19 Dec 2013 10:40:58 GMT

Hi Piyush,

PFA..........

- Regards,

Vishal

Re: Else condition in pick match.

Thu, 19 Dec 2013 11:17:39 GMT

Hi Piyush,

Hope i think help this,

Dev01:

LOAD * Inline

[

Flag,Color

R,RED

G,GREEN,

B,BLUE

Y,YELLOW

];

LOAD Pick(Match(Flag,'R','G','B','Y','W'),Color,Color,Color,Color,Color) as Mat_Val Resident Dev01;

Regards,

Raj.

Re: Else condition in pick match.

Thu, 19 Dec 2013 12:23:56 GMT

Hi Vishal,

Thanks for your suggestion. but if i am not selecting anyfied the text box is showing null. it must show 'grey
'.

Regards

Piyush

Re: Else condition in pick match.

Thu, 30 Oct 2014 22:23:35 GMT

Hi Gysbert,

Please bear with me for very basic question.

Could you please explain how +1 is working in below function.

pick(match(status, 'A', 'B', 'C')+1, 'Grey', 'green', 'Amber', 'Red')

Many Thanks

Re: Else condition in pick match.

Gysbert_Wassenaar — Fri, 31 Oct 2014 09:11:46 GMT

In the case a status other than A, B or C is encountered the match function will return 0 because there is no match. To make sure the pick function will return something it's necessary to add 1 to the result of the match function since the pick function cannot pick the 0-th value in a list. The first parameter of the pick function must be larger than 0.

Re: Else condition in pick match.

Fri, 31 Oct 2014 23:02:18 GMT

Thank you so much

Its clear to me now

Regards,

Pooja