Dynamically change Bar graph shade based on Sales

[raghavsurya]

Dear All,

We are building Daily Sales analysis for our customer.  We have a specific request wherein the customer wants colour shade to be changed/displayed based on Total sales amount.  For Example if 1st of April has done maximum Sales, it should display in Dark Green and other day graphs should be shown in lighted shade in comparison with 1st April's sales. 

Can anyone of you suggest how to achieve this requirement.

Regards,

Raghav

[antoniotiman]

Hi Raghav,

you can use the RangeSum() function in Background color of Text color of Expression,

like this

If(RangeSum(Top(Sum(sales),1,NoOfRows())) = Sum(sales),Green(),Red())

Regards,

Antonio

[antoniotiman]

Sorry,

RangeMax(............                    (Not RangeSum)

[raghavsurya]

Thanks Antonio.  I will work as per suggestion.

[qlik_venu]

You can also try this in the background color.

ARGB(

(

//this will be used for the alpha value of the function.

255*Aggr(Rank(Aggr(Sum(Sales), Country)), Country))

/

count(total Aggr(Sum(Sales), Country)),

17,184,75)

[raghavsurya]

Hi Antonio,

I used your suggested formula and getting only partial result.  Your expression is marking one of the bar (lowest Sales) to red wherein other bars are having Green. 

I need the lowest to have light green and largest in Dark green. The other bars should be between dark and light green (grandiant colors).

Regards,

Raghav

[antoniotiman]

Try Like This :

If(RangeMax(Top(Sum(sales),1,NoOfRows())) = Sum(sales),RGB(0,128,0),If(RangeMin(Top(SumSales),1,NoOfRows()))=Sum(sales),RGB(0,255,0),RGB(0,function(x),0)))

function x is proportional to sum(sales)

You can use RGB or ARGB as you prefer

[Anonymous]

You may wish to have a look at the ColorMix functions, they are described in the QlikView Desktop Help, and there is a Wizard to guide you.