topic Re: pie charts setting default color in QlikView

pie charts setting default color

Tue, 17 Jun 2014 04:28:28 GMT

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

Re: pie charts setting default color

rwunderlich — Tue, 17 Jun 2014 04:48:37 GMT

This technique, "Brushing", is covered in Stephen Redmond's excellent book "QlikView for Developers Cookbook"

http://www.amazon.com/QlikView-Developers-Cookbook-Stephen-Redmond/dp/1782179739/

Attached is an example for your specific question.

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: pie charts setting default color

SergeyMak — Tue, 17 Jun 2014 05:02:01 GMT

Hi,

PFA

I set background color for the expression in this way:

IF(GetSelectedCount(Id)<1,

ColorMix1 ((1+Sign(2*(sum(Value)-RangeMin (top(total sum(Value),1,NoOfRows(total))))/(RangeMax (top(total sum(Value),1,NoOfRows(total)))-RangeMin (top(total sum(Value),1,NoOfRows(total))))-1)*Sqrt(Fabs((2*(sum(Value)-RangeMin (top(total sum(Value),1,NoOfRows(total))))/(RangeMax (top(total sum(Value),1,NoOfRows(total)))-RangeMin (top(total sum(Value),1,NoOfRows(total))))-1))))/2, ARGB(255, 0, 255, 0), ARGB(255, 0,0, 255))

,IF(Match(GetFieldSelections(Id),Id)>=0,green(),RGB(179,179,179)))

Re: pie charts setting default color

Tue, 17 Jun 2014 05:56:47 GMT

hi Rob

i tried doing it exactly the way the book said but with a pie chart not the line chart but it did not work 😕 and i am unable to view you .qvw file cz i am using a personal edition will it be possible for you to send me screen shots plz ??

Re: pie charts setting default color

Tue, 17 Jun 2014 06:00:39 GMT

hi Sergey

since i am using a personal edition i am unable to view you .qvw file. will it be possible for you to send me screen shots plzz??

Re: pie charts setting default color

SergeyMak — Tue, 17 Jun 2014 06:09:30 GMT

Screenshots are attached,

but Rob Wunderlich's solution is much better

Re: pie charts setting default color

Tue, 17 Jun 2014 06:50:39 GMT

hi Sergey

i tried the exact same thing but this did not work is it cz my ID field contains a string value??

Re: pie charts setting default color

SergeyMak — Tue, 17 Jun 2014 06:51:47 GMT

I don't think so.

Can you share your app?

Re: pie charts setting default color

Tue, 17 Jun 2014 06:59:38 GMT

sorry Sergey due to office resources are been used i can not share the app.. 😕

Re: pie charts setting default color

Tue, 17 Jun 2014 07:02:59 GMT

oki i got this working but why dose it show all segments in black initially before i select any thing?? can't i show the segments with the same default colors without green??

Re: pie charts setting default color

SergeyMak — Tue, 17 Jun 2014 07:05:54 GMT

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

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

Re: pie charts setting default color

Tue, 17 Jun 2014 07:14:24 GMT

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

Re: pie charts setting default color

SergeyMak — Tue, 17 Jun 2014 07:24:16 GMT

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

Re: pie charts setting default color

Tue, 17 Jun 2014 08:32:42 GMT

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

Re: pie charts setting default color

Tue, 17 Jun 2014 08:47:23 GMT

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

Re: pie charts setting default color

SergeyMak — Tue, 17 Jun 2014 08:52:22 GMT

Please clarify. I didn't understand.

You can add some screenshots as well

Re: pie charts setting default color

Tue, 17 Jun 2014 09:41:37 GMT

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 😕

Re: pie charts setting default color

SergeyMak — Wed, 18 Jun 2014 00:36:08 GMT

Please show your Background expression

Re: pie charts setting default color

Wed, 18 Jun 2014 03:38:57 GMT

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

sorry for the delay this is the expression that i used

Re: pie charts setting default color

SergeyMak — Wed, 18 Jun 2014 03:49:21 GMT

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

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