Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

coloured bar chart based on value

Hello,

I want to create a bar chart which is primarily very easy and already working. There is only costs based on material numbers. Now i want to colour each bar different, based on the amount behind each material number. The colour change should happen in example 10 steps from red to green, where red is the max. amount and green is the min. amount and all other colours between. How can i create this that this will work dynamic, because daily the data is changing and maybe the min or max gets different. Therefore the colour steps must be different.

Thanks, Armin

Tags (2)
1 Solution

Accepted Solutions
Partner
Partner

Re: coloured bar chart based on value

Try to use this ColorMix Wizard and you will see.

I will try to make a legend for you, but it will be separate straight table and two textboxes with min max values

Regards,
Sergey
14 Replies
vardhancse
Valued Contributor III

Re: coloured bar chart based on value

In chart properties->expressions-> select expression-> back ground color.

as per conditions->bar color will be displayed

ravic906
Contributor III

Re: coloured bar chart based on value

Hello,

choose whatever colors u want in the in the colors section of the properties in the bar chart and sort by y-value either ascending or descending. Even though the values change and max value changes, the maximum values and minimum values of any dimension will always have the same color .

chinnakatikisg
Valued Contributor

Re: coloured bar chart based on value

Hey,

One way is avaliable, if you are having a single expression in your bar chart. You can enable multicolor and sort the x axis based on value of your fact like (sort dimension in x axis based on sum(sales).

char properties.png

Hope this helps,

Regards,

Chinna

Not applicable

Re: coloured bar chart based on value

Hello,

I am still not clear and maybe for better understanding.

I have a bar chart which has on the y-axis the amount of parts by material number and i would like to color the bars based on the costs. As example i made this in another program and i only define the variable and the color left and right and the amount of steps, eg. green to red, 10 steps variable = costs. and the bars gets colored according the legend her. the values 34 and 290 are not fixed, they will change daily but the colors and steps should be still same.

Hope my explaination is better now. Could you send me screenshots how to adjust?

Thanks, Armin

2014-11-10_08-12-37.png

Partner
Partner

Re: coloured bar chart based on value

Hi,

You can always use ColorMix Wizard.

Go to your expression, Plus sign\Background Color\Click ... to see Write expression dialogue and the File\ColorMix Wizard

Regards,

Sergey

Regards,
Sergey
Not applicable

Re: coloured bar chart based on value

Great thanks, and how should the expression in my case looks like to get a dynamic colour calculation?

Thanks

Not applicable

Re: coloured bar chart based on value

and how can i get the legend like in my screenshot into the dashboard?

Partner
Partner

Re: coloured bar chart based on value

Try to use this ColorMix Wizard and you will see.

I will try to make a legend for you, but it will be separate straight table and two textboxes with min max values

Regards,
Sergey
Partner
Partner

Re: Re: coloured bar chart based on value

PFA an example of legend

For the textboxes use a Max Min value of Your expression

Regards,

Sergey

Regards,
Sergey