Combining 2 Pick(Match statements

[#1]

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)) 

[sunny_talwar · Accepted solution]

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()))))