Discussion Board for collaboration related to QlikView App Development.
i have expression like if(status=A,green,
How can we rewrite this Expression using Pick(Match) function for else condition also.
Hope i think help this,
LOAD * Inline
LOAD Pick(Match(Flag,'R','G','B','Y','W'),Color,Color,Color,Color,Color) as Mat_Val Resident Dev01;
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')
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.