pie charts setting default color

[#1]

hi

i have created a pie chart.. normally when we select one data value the pie chart becomes one individual color cz it represent only one value.. is there any possibility that i can fix the pie chart (normally when we select detach the pie chart values wont change/ move) but when i select a particular value except that particular segment, the other segments has to change in to a default color(ash color)

 

this image shows my present display if i select the blue area with the value 11074 i want my pie chart to be displayed as the below image..

if some one can help me in this it would be really appreciated..

thank you in advance

[SergeyMak]

Just use the following expression for background (it's by Rob Wunderlich)

=if(Customer=Customer, color(FieldIndex('Customer',Customer)), LightGray())

[#3]

ok.. i know i am troubling you big time but where am i suppose to put this expression??

[SergeyMak · Accepted solution]

Right Click by chart\Properties..\Expressions\Click + near your expression\Background\

Please change the Customer in

=if(Customer=Customer, color(FieldIndex('Customer',Customer)), LightGray())

to your dimension field

[#5]

omg it worked it worked thank you thank you sooooo much.... u have nooo clue how much i appreciate this thank you sooooo much

[#6]

i still do have a small issue the colors changes to some thin else not the colors what i have applied from the theme why is that??

[SergeyMak]

Please clarify. I didn't understand.

You can add some screenshots as well

[#8]

the colors i had before adding the above equation was some thing similar to this first image..

but after i added the equation to the background the colors changed as shown in the below image..

how can i change the colors back 😕

[SergeyMak]

Please show your Background expression

[#10]

=if(Source=Source, color(FieldIndex('Source',Source)), LightGray()) 

sorry for the delay this is the expression that i used

[SergeyMak]

Right click on the chart\Properties\Colors\Press the button "Get Default Colors"

or

Press Advanced\Retrieve for Sheet Default or Document Default or User Default or QlikView Default