topic color in QlikView

color

Anonymous — Tue, 07 Jun 2011 14:32:37 GMT

I have a multi box and a chart. The multi box allows the user to select various items from a drop down box. H, P, N and so on

I would like to change the color of the in the chart based on what the user select.

Ex: if the user select H, I like the H info in the Chart to be red. If P then I like the P info to be Blue and etc.

How can I do this?

Thanks.

Re: color

Miguel_Angel_Baeyens — Tue, 07 Jun 2011 14:41:49 GMT

Hello,

Go to the chart properties, Expressions, expand using the [+] sign at the left of the expression you want to color, select "Background Color" and set something like

Pick(Match(FieldInMultibox, 'H', 'P', 'N'), LightRed(), Blue(), Green())

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: color

Tue, 07 Jun 2011 14:54:24 GMT

Check this application, This works when user select one value.

This is also very similar solution suggested by Miguel.

Hope this helps you.

- Sridhar