topic Using colours to differentiate values in QlikView

Using colours to differentiate values

Thu, 27 Jan 2011 15:00:16 GMT

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!

Using colours to differentiate values

Thu, 27 Jan 2011 15:39:50 GMT

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

Using colours to differentiate values

matt_crowther — Thu, 27 Jan 2011 16:07:56 GMT

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

Using colours to differentiate values

Thu, 27 Jan 2011 21:11:27 GMT

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

Thanks!!