topic Re: Set color bar by dimension's value in QlikView

Set color bar by dimension's value

Anonymous — Thu, 07 Aug 2014 13:17:53 GMT

Hi!,

I am doing a bar chart with "Empresa" as dimention. The thing is that I want to change the color of one of the bar if Empresa = Omnicrom.

Chart:

I use this formula in colour: If(Empresa='Omnicrom', Red(), Blue())

If I click Omnicrom the bar turns red but when the chart is without a selection all the values has the same colour and I want than Omnicrom always be red.

What can I do?

Thanks from Argentina!

Re: Set color bar by dimension's value

Gysbert_Wassenaar — Thu, 07 Aug 2014 13:25:21 GMT

Where do you use the formula for the color? Did you click on the + in front of the expression, select Background Color and then entered that expression in the Definition field?

Re: Set color bar by dimension's value

Anonymous — Thu, 07 Aug 2014 13:29:25 GMT

I try and works! thanks very much.

Re: Set color bar by dimension's value

crusader_ — Thu, 07 Aug 2014 13:29:52 GMT

Hi,

I've made the same thing.

Here is result.