topic coloured bar chart based on value in QlikView

coloured bar chart based on value

Mon, 10 Nov 2014 06:43:15 GMT

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

Re: coloured bar chart based on value

vardhancse — Mon, 10 Nov 2014 06:48:21 GMT

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

as per conditions->bar color will be displayed

Re: coloured bar chart based on value

Anonymous — Mon, 10 Nov 2014 06:52:30 GMT

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 .

Re: coloured bar chart based on value

Anonymous — Mon, 10 Nov 2014 07:09:58 GMT

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).

Hope this helps,

Regards,

Chinna

Re: coloured bar chart based on value

Mon, 10 Nov 2014 07:16:55 GMT

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

Re: coloured bar chart based on value

SergeyMak — Mon, 10 Nov 2014 07:28:44 GMT

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

Re: coloured bar chart based on value

Mon, 10 Nov 2014 07:32:47 GMT

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

Thanks

Re: coloured bar chart based on value

Mon, 10 Nov 2014 07:37:01 GMT

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

Re: coloured bar chart based on value

SergeyMak — Mon, 10 Nov 2014 07:40:46 GMT

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

Re: Re: coloured bar chart based on value

SergeyMak — Mon, 10 Nov 2014 07:54:48 GMT

PFA an example of legend

For the textboxes use a Max Min value of Your expression

Regards,

Sergey

Re: coloured bar chart based on value

Mon, 10 Nov 2014 09:13:23 GMT

Thanks a lot.

The colouring is working, but i am still not sure how i can get the legend into the dashboard. Furthermore, how can i adjust in the expression formula how many steps the system should calculate.

Re: coloured bar chart based on value

SergeyMak — Mon, 10 Nov 2014 09:18:43 GMT

Just copy the load script, reload app and copy objects form my app and you will get your legend.

You don't need to adjust expression in the legend (table). Only in the two text boxes.

Unfortunately I don't see your expression and your dimensions, but I think it could be something like this:

=Max(Aggr(Sum(Your_Field), Your_Dimension1, Your_Dimension2,..... Your_DimensionN))

and same but Min(...)

Re: coloured bar chart based on value

SergeyMak — Mon, 10 Nov 2014 09:19:27 GMT

Please mark an answer if it was helpful or was a solution..

Re: coloured bar chart based on value

Tue, 11 Nov 2014 05:58:11 GMT

Hello Sergey,

Thanks, one more question.

My expression looks like this:

ColorMix1 ((1+Sign(2*(Sperrdauer-RangeMin (top(total Sperrdauer,1,NoOfRows(total))))/(RangeMax (top(total Sperrdauer,1,NoOfRows(total)))-RangeMin (top(total Sperrdauer,1,NoOfRows(total))))-1)*Sqrt(Fabs((2*(Sperrdauer-RangeMin (top(total Sperrdauer,1,NoOfRows(total))))/(RangeMax (top(total Sperrdauer,1,NoOfRows(total)))-RangeMin (top(total Sperrdauer,1,NoOfRows(total))))-1))))/2, ARGB(255, 0, 128, 0), ARGB(255, 202, 0, 0))

Can you explain me more about this formula and how i can adjust to get always 10 steps?

Thank, Armin

Re: coloured bar chart based on value

SergeyMak — Tue, 11 Nov 2014 06:06:32 GMT

Hi Armin,

It's just generated by Qlikview and It's hard to explain just because I have never tried to understand how it works.

So there're definitely more steps then 10 if you have more then 10 different values in your data

Regards,

Sergey