Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
leandro_abad
New Contributor III

Set color bar by dimension's value

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:

barchart.png

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!

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Set color bar by dimension's value

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?


talk is cheap, supply exceeds demand
3 Replies
MVP & Luminary
MVP & Luminary

Re: Set color bar by dimension's value

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?


talk is cheap, supply exceeds demand
leandro_abad
New Contributor III

Re: Set color bar by dimension's value

I try and works! thanks very much.

Partner
Partner

Re: Set color bar by dimension's value

Hi,

I've made the same thing.

Here is result.result_Italy.png