-
Re: Qlik Sense color expression issue
Mark Ritter Jan 20, 2017 1:07 PM (in response to Hannah McKonly )Where are you putting this expression?
If you replaced your measure with the new version for the colors then it will no longer do what it was doing before.
If want to control colors you should put this expression in the Appearance/Colors and Legends and do a color by expression.
-
Re: Qlik Sense color expression issue
Hannah McKonly Jan 20, 2017 1:13 PM (in response to Mark Ritter)This expression is in the measure for the graph:
avg({<StrategicAim={"Organizational Vitality"}>}ObservedNumerator)
This expression is in the color by expression field:
IF (DesiredDirectionUp=-1,
IF (AVG({<StrategicAim={"Organizational Vitality"}>}ObservedNumerator)
>=
avg({<StrategicAim={"Organizational Vitality"}>}[Target (OHTargets)]),red(),green()),
IF (AVG({<StrategicAim={"Organizational Vitality"}>}ObservedNumerator)
<=
avg({<StrategicAim={"Organizational Vitality"}>}[Target (OHTargets)]),Green(),Red()))
-
Re: Qlik Sense color expression issue
Megan Rawson Feb 3, 2017 5:44 PM (in response to Hannah McKonly )I am having the same issue with a set of charts I am making. I have trend charts by FY. I only want to show the trend for 2 years and I want to specify what color each year is.
Making the chart is easy, but when I use the color by expression I get data for the other FY equal to all zeros which makes my trend line look flat.
When I changed my equation from set notation to if statements I was able to specify the colors of the lines without any problems.
-
-