Conditional Coloring

[#1]

Hi guys,

I've been trying to do some searching for conditional expressions, but I haven't had any luck so far.

Right now I have two KPIs. One that shows Revenue from 2014 and one from 2015.

I did set analysis to filter the revenue by the year:

2014 Revenue Expression: Sum({$<Year={"FY14"}>}"Revenue")

2015 Revenue Expression: Sum({$<Year={"FY15"}>}"Revenue")

Now, I would like the 2015 Revenue to be a certain color depending on if it's higher or lower than 2014 Revenue (example: red if lower, green if higher).

I checked conditional coloring, but I'm a little confused as to how the expression should be formatted (most likely an if expression?).

Any help would be greatly appreciated. Thanks!

[phaneendra_kunc]

Hmmm...What version are you on? are you on version 1.1? or 1.0.x?

[#3]

I'm on 1.1

[phaneendra_kunc]

Thats odd. im on 1.1 too. So when you opened up my attached example is it working?

When you select "A2Z solutions" you should see GREEN

and when you select "Active Data" you should see RED.

It should have been nice if we have option like Color by expression that we have in Table. May be they will come up with next versions 2.0 and later.

[#5]

That's a good point actually.

On your file, yes the colors work. I managed to get the colors to work on mine too.

On your file, can you try adding a ^ to the green and a v to the red? (glyphs)

They do not seem to work or update correctly.

[phaneendra_kunc · Accepted solution]

glyphs are not working. It always picks one and doesnt show conditionally.

May be can use like the one in attached.

[#7]

Hmm, do you know why the glyphs are behaving that way? Seems so strange. I would love to be able to get it to work properly.

Thanks for all your help so far!

[phaneendra_kunc]

Not sure why. May be it is a bug. As i said earlier it will be great if qlik can add conditional coloring in later releases.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Thanks,

Phani