Change button color if selection on field is equal to

[qlikviewaf]

Hi guys,

i would like to have the button with different color based on the selection on "Item_Category" field.

I set the color configuration as

=if(Match(Item_Category,'FRT' and 'IMP' and 'IMPU' and 'SCN' and 'SMP'),RGB(153,204,255),RGB(192,192,192))

if selection on the field Item_Category= 'FRT' and 'IMP' and 'IMPU' and 'SCN' and 'SMP' then color of button RGB(153,204,255) else

How i can set my expression?

thanks!

[Kushal_Chawda]

use Pick(match(

Pick(Match(Item_Category,'FRT' ,'IMP' ,'IMPU' ,'SCN' ,'SMP'),

RGB(153,204,255),

RGB(192,192,192),

RGB(..),

RGB(..),

RGB(..))

[qlikviewaf]

seems that this not works for me.

I try to explain my self better:

if the selection is FRT+IMP+IMPU+SCN+SMP at the same time, so i need to have just 2 color:.

FRT+IMP+IMPU+SCN+SMP -> one color

other selection different than (FRT+IMP+IMPU+SCN+SMP) -> anoter color

[Kushal_Chawda]

if(Match(Item_Category,'FRT' ,'IMP' ,'IMPU' ,'SCN' ,'SMP'),

RGB(153,204,255),

RGB(192,192,192))

[qlikviewaf]

Not working, don’t now why..