How to change colour of bar according to the value compared with adjacent bar in Qliksense?

[hosasahana]

Hi all,

Request help in getting a logic for my development. 

I have a bar chart where x axis is month and there is each bar value calculated for every month, basically dimension is month and measure is an avg calculation. I want to change the colour of the bars to red and green according to a particular logic.  

if current month (Dec) >previous month (Nov) = green, else red 

if Nov >Oct = green else red.

Similarly for all months. Is this possible in Qliksense? if yes,please can you help?

Thanks,

Sahana

[hosasahana]

hi, can anyone help on this issues please?

[Zhandos_Shotan · Accepted solution]

Hi,

Use Color by Expression option, and expression:

If(avg(Value)>Above(avg(Value)), Green(), LightRed())

[hosasahana]

hi Zhandos,

Thankyou so much. Above function does the work. great!!