Using colours to differentiate values

[#1]

I need to use 2 colors to differentiate on a chart when change the value of a dimension compared to the previous value. Is it possible to leave it as shown in the picture?

Usually i do these things using a macro in Excel but this time i need it in Qlikview.

Thanks!

[#2]

Hello,

You could try this expression for the background of your Dimension Terminal -> if (Name = aaa,YELLOW(), BLUE()).

You need to modify the above expression a bit, but its around this...please try

Mama

[matt_crowther · Accepted solution]

This one seems to be trickier than it should be...never the less I have a possible solution:

The only soloution I could come up with I'm affraid is more script based and isn't 100% robust but may well be of use - look at the script and the Dimension BackGround colour and I'm sure you'll be able to decode it.

File attached.

Hope that helps,

Matt - Visual Analytics Ltd

[#4]

Excelent Matt, i was wondering if would be necesary something similar using autogenerate, but your solution is perfect and very useful.

Thanks!!