topic Re: Bar Color in Combo Chart in QlikView

Bar Color in Combo Chart

nihhalmca — Wed, 26 Feb 2014 11:05:14 GMT

Hi All,

I want to change single bar color in combo chart.

For Example: Dim = Product

Measure 1: Quantity

Measure 2: Price

Measure 3: Revenue

Note: Measure 1 & 2 are grouped (Drilling in Expression).

However My Requirement is, should display Quantity (Bar) is in Red color and Price (Bar) is in Green color. (When i click drill in chart)

Thank You.

Regards,

NiHhal.

Re: Bar Color in Combo Chart

stevedark — Wed, 26 Feb 2014 11:44:07 GMT

If you drill on the expression you can enter code for the bar colour, it will need to be something like:

=if(Only(Product) = 'Quantity', rgb(255, 100, 100),

if(Only(Product) = 'Price', rgb(100, 255, 100),

if(Only(Product) = 'Revenue', rgb(100, 100, 255), null())))

Null will revert back to the colours on the colour tab of the chart.

I tend to always put colours in variables, so that the colour can be changed in one place regardless of where it appears, eg:

=if(Only(Product) = 'Quantity', $(vColQuantity),

if(Only(Product) = 'Price', $(vColPrice),

if(Only(Product) = 'Revenue', $(vColRevenue), null())))

Hope that helps,

Steve Dark

Re: Bar Color in Combo Chart

nihhalmca — Wed, 26 Feb 2014 11:59:53 GMT

Thanks for swift reply,

Please let me know where can i paste exactly this script.

Actually i want to change color only for Quantity Bar.

NiHhal.

Re: Bar Color in Combo Chart

Clever_Anjos — Wed, 26 Feb 2014 12:04:53 GMT

Each expresion as an small "+" just beside it.

Click on it and set "Background Color"

Re: Bar Color in Combo Chart

stevedark — Wed, 26 Feb 2014 12:19:15 GMT

Thanks Clever.

Nihal, if you follow Clever's screenshot you can find the Background Colour code. The code will be:

=if(Only(Product) = 'Quantity', rgb(255, 100, 100),

if(Only(Product) = 'Price', null(),

if(Only(Product) = 'Revenue', null(), null())))

Obviously you could simplify to take out the IF statements for Price and Revenue - but this will allow you to drop in other colours at a later date if you wish.

Re: Bar Color in Combo Chart

Clever_Anjos — Wed, 26 Feb 2014 12:22:52 GMT

Steve Dark, I think Nihhal L wants to see each bar with differente colors, right?

Maybe you don´t need an IF statement, a fixed lightred() and lightgreen() should work on each bar

Re: Bar Color in Combo Chart

stevedark — Wed, 26 Feb 2014 12:56:25 GMT

Apologies, I missed that they were different expressions rather than dimensions. In that case the simpler approach would be to go to the colours tab and click the multicoloured tick box and set colours 1, 2 and 3 through the UI. Doing it in code perhaps the more robust though.

Re: Bar Color in Combo Chart

nihhalmca — Thu, 27 Feb 2014 06:03:14 GMT

Thank You Clever Anjos.

NiHhal.