topic Pie Chart - same color for value/field, also when order changes in QlikView

Pie Chart - same color for value/field, also when order changes

Thu, 10 Nov 2011 19:37:55 GMT

I have a Pie Chart with one Dimension (Department) and I want to set a specific color for each department. i.e Opex = brown, Z + R = blue, Part M = green ...

If the order changes (i.e. Z + R is 2nd or 3rd) then the department should still have the same color, Opex = red, Z + R = green, Part M = blue ...,

How can I define individual color for eych value of the dimension used in the Pie Chart, even if a value is numer 1 oder number 7?

Edit:

Here is another example. I have cities and the colors change when I select different times. But I need the same color for the same city, even when the city is first or last.

thank you

Pie Chart - same color for value/field, also when order changes

Anonymous — Thu, 10 Nov 2011 19:59:50 GMT

Just check the "persistent color" checbox on color properties. Colors will be stable, at least until next reload.

Re: Pie Chart - same color for value/field, also when order changes

Thu, 10 Nov 2011 20:03:36 GMT

Open, Expression box and set the colors based on dimension values in the background color.

Enhancing this feature, you can have the colors RGB/brown,red,etc in data model and call them here.

say Dept,DeptColor; your expression would be =DeptColor

Kiran.

Pie Chart - same color for value/field, also when order changes

Thu, 10 Nov 2011 20:16:26 GMT

Thanks, thats the solution. The only thing now is, I have a if-statement with 7 stages

=if(city='Hamburg',rgb(10,110,100),if(city='Rostock',rgb(210,220,200),if(city='München',rgb(30,230,200),if(city='Berlin',rgb(40,40,100),if(city='Köln',rgb(50,50,500),if(city='Leipzig',rgb(60,60,100), if(city='New York',rgb(70,20,200))))))))

Is there a better way?

Pie Chart - same color for value/field, also when order changes

Thu, 10 Nov 2011 20:18:38 GMT

You could place this if statment in your script and then just place the field in the Backround expression box

Pie Chart - same color for value/field, also when order changes

Thu, 10 Nov 2011 20:19:33 GMT

In your script add a inline load of

city,CityColor

Hambur,rgb(10,110,100)

Rostock,rgb(210,220,200) etc...

In the formula have it as =CityColor

This should be lite on your expression and easily mainainable.

Kiran.

Pie Chart - same color for value/field, also when order changes

Anonymous — Thu, 10 Nov 2011 20:37:30 GMT

If all you need is a consistency of colors, my suggestion about the checkbox is more than enough.

Hardcoding colors in the script is relaible, but it makes sense only if you need more than simple consistency, e.g. the same colors for the same Cities all the time - but in this case you have to ensure that the list of cities is static, no new values. If the list of cities may change, there will be more complications that I consider unnecessary.

Pie Chart - same color for value/field, also when order changes

Thu, 10 Nov 2011 20:39:37 GMT

Thanks, thats what I need, the same color for the same city all the time, even if they change their order.

Re: Pie Chart - same color for value/field, also when order changes

Thu, 10 Nov 2011 20:52:21 GMT

Hi Kiran,

when I add the color into the table then my Pie Chart is all black. Do you have a suggestion? I tried both, 1) adding the color into the inline table and 2) creating a new table with the color.

Pie Chart - same color for value/field, also when order changes

Thu, 10 Nov 2011 21:28:41 GMT

I think QV doesn't recognize a value = RGB( 10,100, 200). Why I don't know.

But if you create 3 fields corresponding of the 3 colors, it works with the formula RGB( R , V , B) in background color

color:

LOAD * INLINE [

R,V,B, city

10,110,100, Hamburg

210,220,200, Rostock

30,230,200, München

40,40,100, Berlin

50,50,200, Köln

60,60,100, Leipzig

100,100,200', New York

];

Re: Pie Chart - same color for value/field, also when order changes

Thu, 10 Nov 2011 21:40:34 GMT

Thank you, this works perfectly. You were right, QV does not recognize the values rgb(1,1,1), but it works with 3 fields.

Thanks to all, the QV Community really is the best.

Pie Chart - same color for value/field, also when order changes

Wed, 11 Apr 2012 17:20:31 GMT

Hi everyone,

I have a similar problem, but in my case, I have a scatter chart and i need a diferente color by each field value. In another words:

I have this on my script

color:

LOAD * INLINE [

R,V,B, Firmware

101,100,121, +31J2

210,220,200, +31J8

30,230,200, 5.80C

40,40,100, 5.81C

50,50,200, 5.83C

60,60,100, 5.83Z

100,100,200, 5.87C

100,100,200, 5.92C

100,100,200, 5.92T

100,100,200, 5.96E

];

And this configuration for expression (Delta is the value plotted in the scatter chart area). The persistent color is no checked.

What can be wrong? anybody help me?

Thanks

Pie Chart - same color for value/field, also when order changes

Anonymous — Thu, 12 Apr 2012 01:30:57 GMT

Guiliano,

Your dimension should be Firmware. The color expression should be on the dimension, not on the expression.

Regards,
Michael
PS: Advice - create new question rather than adding replies to the existing one if you want more users to read it. Second, this thread is marked as "answered", even less chances someone reads it. Third, your question is not even about pie chart...

Pie Chart - same color for value/field, also when order changes

Thu, 12 Apr 2012 15:31:04 GMT

Hi Michael,

Thanks for your answer, your suggestion was really useful, because part of my problem is solved.

I sorry for my mistake, I start a new thread for my situation. http://community.qlik.com/thread/51240

Thanks

Giuliano Caetano