Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi

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
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
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.
write color code in Expression
if(field=Value1,color1
if(field=value2,color2
if(field=value3,color3
if(field=value4,color4
))))
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)
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

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?
sorry ..confidential
Your dimensions and expressions and chart settings are confidential?
Well, then my answer is confidential, too ![]()
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])))