topic Re: Issue on pie chart background color in QlikView

Issue on pie chart background color

Wed, 25 Nov 2020 16:16:04 GMT

Here green--->Allowed

Red---->not allowed

blue--->Hold

orange---->Allowed shortly

i wrote condition like this--->IF(GetCurrentSelections(stage)>0,color(FieldIndex('stage',stage)),color(FieldIndex('stage',stage)))

my issue is when i am reloading the application the colors are changing .like this

green--->not allowed

Red---->Allowed

blue--->Hold

orange---->Allowed shortly

Thanks,

siddiq

Re: Issue on pie chart background color

swuehl — Tue, 17 May 2016 23:05:41 GMT

Not sure if I fully understood your conditional to set the color (isn't the THEN and ELSE branch identical?), but if you want to keep consistent colors for your stages, have a look at

Colors in charts

Re: Issue on pie chart background color

Chanty4u — Wed, 18 May 2016 05:10:26 GMT

Otherwise.

if u want to maintain the particulars in pie or .. u can set first 1-6 and 6-12 colours by uaa own and apply.

Re: Issue on pie chart background color

SunilChauhan — Wed, 18 May 2016 05:55:04 GMT

write color code in Expression

if(field=Value1,color1

if(field=value2,color2

if(field=value3,color3

if(field=value4,color4

))))

Re: Issue on pie chart background color

Kushal_Chawda — Wed, 18 May 2016 06:04:42 GMT

Go to pie chart expression, in background color try below condition

=pick (match(Field,'Allowed','Not Allowed','Hold','Allow Shortly'),

red(), green(),blue(),orange())

if any color function is not recognize then use RGB(value1,value2,value3)

Re: Issue on pie chart background color

Wed, 18 May 2016 15:19:26 GMT

i have applied above two expressions but by default one field value taking Black color when i click on the field i am getting pie chart something like below(completely Black).i need all four colors should be user defined

Re: Issue on pie chart background color

swuehl — Wed, 18 May 2016 15:27:00 GMT

Could you please post a small sample QVW that shows that issue or at least all dimensions / expressions / modified chart settings of that pie chart?

Re: Issue on pie chart background color

Wed, 18 May 2016 15:34:45 GMT

sorry ..confidential

Re: Issue on pie chart background color

swuehl — Wed, 18 May 2016 15:39:43 GMT

Your dimensions and expressions and chart settings are confidential?

Well, then my answer is confidential, too

Re: Issue on pie chart background color

Wed, 18 May 2016 16:27:32 GMT

sorry...yar my dimension is State Name and expression count({1}[State])

In background color :

=if(GetCurrentSelections([State])>0,color(FieldIndex(' State',[State])),color(FieldIndex('State',[State])))

Re: Issue on pie chart background color

swuehl — Wed, 18 May 2016 20:39:35 GMT

Still not sure how your THEN and ELSE branch differ.

If you are using a set identifier like {1} in your expression, you will still see all pie chart segments even when the current selection excludes some values.

In your color expression, you don't cater for possible user selections, so [State] in the aggregation scope might render to NULL for some segments where the user selections should exlcude this value.

Try something like

=if(GetCurrentSelections([State])>0,color(FieldIndex(' State',Only({1}[State]))),color(FieldIndex('State',Only({1}[State]))))

or maybe just

=Color(FieldIndex('State', Only({1} [State]) ))

Re: Issue on pie chart background color

MarcoWedel — Wed, 18 May 2016 20:48:04 GMT

Hi,

maybe helpful:

Re: Hopefully quick question about calculated colours!

regards

Marco