Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
This feature was added in MAy 2021 version
Alright. Is there any work around if upgrade is not an option for me.