Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
michaelneck
Contributor II
Contributor II

Multiple Pick Match For Colours Question

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

3 Replies
sunny_talwar

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

))

michaelneck
Contributor II
Contributor II

Thanks a million! Silly mistake, should have spotted it

sunny_talwar

No problem at all