topic Re. :Re: Color & Bar Chart in QlikView

Color & Bar Chart

Tue, 01 Dec 2009 00:32:11 GMT

Hi,

I have a bar chart with one dimension (cities for example).

I want to assign for each bar a color depending of another dimension (country for example).

Is it possible to do this on the graphic ?

Thanks for your help

Jean-Jacques

Color & Bar Chart

prieper — Tue, 01 Dec 2009 00:37:14 GMT

Open the small "+" below the expression. Under "Background" you may formulate your conditions, e.g. IF(country = 'France', 'LIGHTBLUE')

Peter

Re. :Re: Color & Bar Chart

Tue, 01 Dec 2009 00:40:21 GMT

Is There no other method using group dimension ?

Re. :Re: Color & Bar Chart

prieper — Tue, 01 Dec 2009 00:43:54 GMT

You may group your cities and refer to the grouping: IF(continent = 'EUROPE', BLUE(), IF(continent = 'USA', RED())). You may also load a table with countries and desired colours and refer in the calculation to it.
Or have I understood you wrongly?

Peter

Re. :Re: Re. :Re: Color & Bar Chart

Tue, 01 Dec 2009 00:58:21 GMT

Thanks Peter, you understood well

I like the idea to create a table but I don't know how to assign color for each DEX (is my dimension) in the background. I tried all...

I created

Load * Inline [
DEX, COLOR
AJACCIO DPC,red()
BORDEAUX DEX-ELP SUD OUEST,blue()
LYON DEX-ELP CENTRE EST,green()
MARSEILLE DEX-ELP SUD EST,yellow()
PARIS DEX-ELP ILE DE FRANCE,black()
RENNES DEX-ELP OUEST,lightblue( )
VILLENEUVE D ASCQ DEX-ELP NORD EST,cyan()];

Re. :Re: Re. :Re: Color & Bar Chart

Tue, 01 Dec 2009 02:45:50 GMT

I understood now my problem.

I must apply the backgroung color on the expression and not on the dimension. It works fine now.