Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

sergey_maka8
Valued Contributor

Re: pie charts setting default color

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

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

Not applicable

Re: pie charts setting default color

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

sergey_maka8
Valued Contributor

Re: pie charts setting default color

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

Not applicable

Re: pie charts setting default color

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

Not applicable

Re: pie charts setting default color

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??

sergey_maka8
Valued Contributor

Re: pie charts setting default color

Please clarify. I didn't understand.

You can add some screenshots as well

Not applicable

Re: pie charts setting default color

Untitledc.pngthe 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 Untitledv.pngthe below image..

how can i change the colors back :/

sergey_maka8
Valued Contributor

Re: pie charts setting default color

Please show your Background expression

Not applicable

Re: pie charts setting default color

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

sorry for the delay this is the expression that i used

Highlighted
sergey_maka8
Valued Contributor

Re: pie charts setting default color

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