topic Multiple Pick Match For Colours Question in QlikView

Multiple Pick Match For Colours Question

michaelneck — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am trying to create a condition on whether a certain year in the calendar is selected then an expression value (Background Colour) in a chart will be chosen. Each work individually but not nested in the if formula. Just wondering if anyone could help me out?

Thanks

=if(GetFieldSelections([Payroll Year])=$(vLastYear),

PICK(MATCH([Performance Most Recent Rating Last Year], 'High', 'Medium', 'Low'), $(v_colour_green), $(v_colour_yellow), $(v_colour_red)),

if(GetFieldSelections([Payroll Year])=$(vMinus2Years),

PICK(MATCH([Performance Most Recent Rating Minus2 Years], 'High', 'Medium', 'Low'), $(v_colour_green), $(v_colour_yellow), $(v_colour_red)),

PICK(MATCH([Performance Most Recent Rating], 'High', 'Medium', 'Low'), $(v_colour_green), $(v_colour_yellow), $(v_colour_red))

Re: Multiple Pick Match For Colours Question

sunny_talwar — Fri, 05 Jan 2018 16:13:20 GMT

Did you miss the two closing parenthesis by mistake? Those are needed if you don't have them

=if(GetFieldSelections([Payroll Year])=$(vLastYear),

PICK(MATCH([Performance Most Recent Rating Last Year], 'High', 'Medium', 'Low'), $(v_colour_green), $(v_colour_yellow), $(v_colour_red)),

if(GetFieldSelections([Payroll Year])=$(vMinus2Years),

PICK(MATCH([Performance Most Recent Rating Minus2 Years], 'High', 'Medium', 'Low'), $(v_colour_green), $(v_colour_yellow), $(v_colour_red)),

PICK(MATCH([Performance Most Recent Rating], 'High', 'Medium', 'Low'), $(v_colour_green), $(v_colour_yellow), $(v_colour_red))

))

Re: Multiple Pick Match For Colours Question

michaelneck — Fri, 05 Jan 2018 18:16:32 GMT

Thanks a million! Silly mistake, should have spotted it

Re: Multiple Pick Match For Colours Question

sunny_talwar — Fri, 05 Jan 2018 18:27:19 GMT

No problem at all