Discussion Board for collaboration on QlikView Layout & Visualizations.
Can someone help me to change the color of a particular bar in a chart, according to the user color selection.
I save user selection in some variables, but when I try to set the stored RGB value, it doesn't work.
The table has this structure:
Type, Type_var, Value
type1, v_type1, 6
typeN, v_typeN, k
In attach you can find an example of the situation.
Try this expression for the Background color of the chart expression:
pick(match([Type_var],$(=Concat(chr(39) & Type_var & chr(39) ,',', Type))),
$(=concat( '$'& '(' & [Type_var] & ')' ,',', Type))