topic Re: Re: Bar chart color not correct in QlikView

Bar chart color not correct

Tue, 08 Jul 2014 08:41:18 GMT

Hello to all the community,

I am trying to color the bars of a bar chart depending on the values that the bars have, like on the example in attachment.

I have a condition on the background color property of the chart. This condition is an if statement:

=if([NumeroIncidenciasMPV]=max(NumeroIncidenciasMaximoMPV,1),Lightred(),Lightgreen())

This is suppose to paint the largest bar with red.

But with this condition all the bars are painted red, but if I use:

=if([NumeroIncidenciasMPV]=4,Lightred(),Lightgreen())

only the first one is red, and this is what I need, but I need the value to be dynamic, so I have to use the expression max(NumeroIncidenciasMaximoMPV,1) or a variable containing its value.

I checked the value of max(NumeroIncidenciasMaximoMPV,1) and it is 4, so I don't understand why this is not working.

Could anyone help?

Thank you!

Re: Bar chart color not correct

MK_QSL — Tue, 08 Jul 2014 08:49:01 GMT

IF(Rank(SUM{1}NumeroIncidenciasMPV)) = 1, Lightred(), LightGreen())

Re: Bar chart color not correct

Tue, 08 Jul 2014 08:55:26 GMT

Tank you!

This works, but only for the first bar. What if I want to make something like on the new attachment?

Re: Bar chart color not correct

MK_QSL — Tue, 08 Jul 2014 08:58:15 GMT

IF(Rank(SUM{1}NumeroIncidenciasMPV),4) = 1, Lightred(), LightGreen())

Re: Re: Bar chart color not correct

jsingh71 — Tue, 08 Jul 2014 09:01:04 GMT

Use variables and assign the calculated values in your chart.

For your reference please find attachment.

Re: Bar chart color not correct

Tue, 08 Jul 2014 09:06:49 GMT

That statement colors the bars one by one.

Is there a way to color all the bars with the same result with the same color, for example:

All the bars with result=4 with red, all the bars with result=3 yellow and so fort.

Re: Bar chart color not correct

engishfaque — Tue, 08 Jul 2014 09:12:19 GMT

Dear Ivo,

Solved problem, please check attached screenshot.

Kind regards,

Ishfaque Ahmed

Re: Bar chart color not correct

Tue, 08 Jul 2014 09:46:03 GMT

Hello Ishfaque,

Consider this, what if the value 27 comes from a variable and this variable contains a dynamic value that comes from an expression, for example a max(FIELD) expression.

Because I tried to do this (with the variable) and does not work, all the bars are painted the same color.

Re: Bar chart color not correct

engishfaque — Tue, 08 Jul 2014 10:15:08 GMT

Dear Ivo,

Please find attached screenshots.

Kind regards,

Ishfaque Ahmed

Re: Bar chart color not correct

Tue, 08 Jul 2014 10:30:05 GMT

Thank you for the reply Ishfaque,

I follow all the step you showed me, the only difference is that you set the value 27 to the variable and I set the expression:

max(NumeroIncidencias)

and with this all the bars are colored red... I have a textfield on the side of the chart to check the value of my $(maximoIncidencaisMPVA) and the value is 4.00000000... Could this influence the if statement?

Re: Bar chart color not correct

engishfaque — Wed, 09 Jul 2014 07:53:21 GMT

Dear Ivo,

These screenshots will help you, please find attached.

Moreover, you can do it by using following expression.

Background Color > Defination > =If(Max(your_field_name), RGB(0,255,0))

Kind regards,

Ishfaque Ahmed