topic Re: conditional colors in Bar Chart in QlikView

conditional colors in Bar Chart

Thu, 04 Dec 2014 13:30:56 GMT

Hi all

I tried to change color in a bar chart for Min and Max with following formula:

=if(sum({<[Fact.Type] = {'Sales'}>}Fact.Net_Rev_EUR)/Count (DISTINCT Fact.Order)={'$(=Min(sum({<[Fact.Type] = {'Sales'}>}Fact.Net_Rev_EUR)/Count (DISTINCT Fact.Order))'},RGB(255,0,0),RGB(0,0,0))

Could somebody helpm me with the formula?

thanks

Oliver

Re: conditional colors in Bar Chart

alexandros17 — Thu, 04 Dec 2014 13:34:47 GMT

if(

sum({<[Fact.Type] = {'Sales'}>}Fact.Net_Rev_EUR)

Count (DISTINCT Fact.Order)

Sum({'$(=Min(sum({<[Fact.Type] = {'Sales'}>}Fact.Net_Rev_EUR)

Count (DISTINCT Fact.Order)

,RGB(255,0,0)

,RGB(0,0,0)

)

Let me know

Re: conditional colors in Bar Chart

Thu, 04 Dec 2014 13:39:12 GMT

unfortunately it doesn't work

Re: conditional colors in Bar Chart

Anonymous — Fri, 05 Dec 2014 10:46:25 GMT

Hi Oliver,

Not sure if you have resolved this yourself but when dealing with dynamic colours like this I try to break out the functions in a table first to make sure they are behaving as expected. With your set analysis statements it would be very easy for a mistake to slip in. I would also consider bracketing each half of the comparison to make sure there is nothing odd going on.

Finally, be wary of direct comparison between non integer values, you might get interesting rounding artifacts which would give you unexpected results.