topic Combining 2 Pick(Match statements in QlikView

Combining 2 Pick(Match statements

Tue, 16 Feb 2016 20:49:07 GMT

Hello,

I'm trying to come up with a solution for combing two pick match statements. We need the color of the chart to be dependent on the year, and the bar graph has two layers: Secondary and New Issue. How can I accomplish this?

Pick(Match(Only({<Market>} Market), 'Secondary', 'New Issue'), RGB(201,187,23), RGB(45,64,199))

Pick(Match(Only({<Year>} Year), $(vMaxSelectedYr), ($(vMaxSelectedYr)-1), ($(vMaxSelectedYr)-2)), RGB(201,187,23), RGB(45,64,199), RGB(34,235,2))

Re: Combining 2 Pick(Match statements

sunny_talwar — Tue, 16 Feb 2016 21:28:52 GMT

Please look my response to your previous thread: Re: Help with setting bar chart color based on year‌

=Pick(Match(Only({<Year>} Year), $(vMaxSelectedYr), ($(vMaxSelectedYr)-1), ($(vMaxSelectedYr)-2)),

(If(Only({<Year>} Market) = 'Secondary', RGB(201,187,23), blue())),

(If(Only({<Year>} Market) = 'Secondary', RGB(45,64,199), cyan())),

(If(Only({<Year>} Market) = 'Secondary', RGB(34,235,2), If(Only({<Year>} Market) = 'New Issue',RGB(100,200,210),Green()))))