topic Re: Graph Colors Change with Data (based on expression) in QlikView

Graph Colors Change with Data (based on expression)

Thu, 07 Mar 2013 19:07:47 GMT

I'm trying to get graph to display Bar colors based on data Values. So far it only takes value of first data set . For example if Group(X Axes) is below 50 then all bars turn same color as the first bar (Red). How can I get Bars to change to color according to Data based on Group(X Axes).

Example: Group1 >50 Then Green , Group2 < 50 Then Red, etc...

This is the formula I'm trying

= if(avg([ Group %Tile]) >= 50 ,RGB(0,145,72), RGB(237,28,46))

RGB are custom colors for report

Re: Graph Colors Change with Data (based on expression)

Thu, 07 Mar 2013 19:28:48 GMT

Hi!

Try putting the formula in place as shown below:

Att.

Rebeca

Re: Graph Colors Change with Data (based on expression)

Thu, 07 Mar 2013 20:10:21 GMT

Rebecca,

Thank you . It works adding it to the Background Color .

Thank you....

Re: Graph Colors Change with Data (based on expression)

Thu, 07 Mar 2013 20:10:35 GMT

Rebecca,

Thank you . It works adding it to the Background Color .

Thank you....

Re: Graph Colors Change with Data (based on expression)

Thu, 07 Mar 2013 20:11:44 GMT

This was the answer. Thank you.....

Re: Graph Colors Change with Data (based on expression)

Mon, 23 Sep 2013 15:20:51 GMT

Thank you so much!