Qlik Community

Qlik Sense App Development

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

mikegrattan
Contributor II

Color Expression in bar chart for alternative measure

I have a bar chart with a regular measure and an alternative measure.  I would like to color the bars based on the value of the selected measure. If the measure evaluates to a negative number (<0), then color it red, otherwise make it green.  This formula works for the primary measure:

if($(vTotProfLoss) <= 0,Red(),Green())

But if I expand this expression to also evaluate the alternative measure, it doesn't work.  I guess I need to find out if there's a way to tell which measure has been selected by the user, and then apply the correct color expression.

Anyone have a suggestion as to how I can do this?

Thanks!