Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

gdipasquale1
New Contributor

color expression in bar diagram

Hi,

I have a bar diagram with 1 dimension and 2 measures :

Capture3.PNG

I would like to use diffrent colors for my bars in comparing them.

For example, I would like that for a given month, the biggest value will be set in green and the lowest in red.

Is it possible by simply comparing the 2 bars ?

Or should I create a color expression using the code of my bars ?

Code behind bars :

column 1 :

Sum({$<OPERATION_VALUE_DATE.autoCalendar.Year={2017}>}OPERATION_ACCRUED_INT_AMOUNT_EUR)


column 2 :

Sum({$<[OPERATION_VALUE_DATE.autoCalendar.Year] = {2018}, [OPERATION_VALUE_DATE.autoCalendar.Date] = {"<=28/02/2018"}>}OPERATION_ACCRUED_INT_AMOUNT_EUR)

I've tried to write such expression but without success.

Perhaps there is a simple way to do that ?

Thanks for your help.