to use different colors for two measures using color by expression

[taha_mansoor]

Hi All

I have a case where I am using two measures in combo chart. Measure1 is Sales and Measure2 is Budget. My Sales values is going -ve in november month which I need to show as positive. My original chart looks like below:

I am using fabs() to make the -ve value +ve and using color by expression where I am using this expression: if(Sum(Sales)<0, Red, Blue()) and then my chart appears as below:

The problem here is that the Measure2 representation, i.e. line, also takes the impact of the color expression which I don't want. I want the budget line(Measure2) to be single color (yellow) as show in my original char above and Sale bars(Measure1) color to be dynamic based on the expression I have written in color by expression section.

Any idea how to control this? do I need to control via expression code or is there any feature that can help?

I can't go for color by measure using segments color definition inside the master measure because when I am defining the expression for my master measure I am already using fabs() in it to make the value positive, hence it will not get any -ve value at all, I believe.

I am using Qlik Sense Enterprise on Windows June 2020 version.

Thanks 

Taha

[vinieme12]

This feature was added in MAy 2021 version

https://help.qlik.com/en-US/sense-developer/November2021/Content/Sense_Helpsites/WhatsNew/What-is-ne...

[taha_mansoor]

Alright. Is there any work around if upgrade is not an option for me.