persistent color pie chart

[adiarnon]

hi,

i have a pie chart with

expression:

count({<Rate_MonthYear={"$(v_early)"}>}DISTINCT Central_BP)

dimention:

=if(aggr((sum({<Rate_MonthYear={"$(v_early)"}>}MONTHLY_ON_TIME_UNITS_QTY)/sum({<Rate_MonthYear={"$(v_early)"}>}MONTHLY_RCVD_UNITS_QTY)),Central_BP)>=0.95,'Preferred',
if(aggr((sum({<Rate_MonthYear={"$(v_early)"}>}MONTHLY_ON_TIME_UNITS_QTY)/sum({<Rate_MonthYear={"$(v_early)"}>}MONTHLY_RCVD_UNITS_QTY)),Central_BP)>=0.85,'Satisfactory','Unsatisfactory'))

i checked th "persistent color"

i have 3 colors and if when im chossing 2 of them its behaiving good (keep the color)

but the third color if im chossing it it changing!

what am i doing wrong?

adi

[Gysbert_Wassenaar]

I don't understand what you're trying to do in the first place. Can you post a small qlikview document that demonstrates the problem?

[adiarnon]

i have a problem with upload documents in my company 😕

my pie chart have dimention with 3 values

'Preferred' (green)

'Satisfactory' (yellow)

'Unsatisfactory' (red)

i want that each value will have a color

no meter what im selecting

how can i do it?

[#4]

are yiou using the colors on the colr tab (the first 3) and checking 'persistant colors' or are you coding colors in your expression to make sure you get

'Preferred' (green)

'Satisfactory' (yellow)

'Unsatisfactory' (red)

By just using the color tab, the colors are picked by the system based on volume, which can change.  It sounds like since you want certain colores to represent status, you want to place your colors in the background color of your expression(s)

[adiarnon]

hi tnx

but,

i tried and its not working...

the color chainging by th edimention and not by the expression

adi

[#6]

you can place an if test within the background color expression

an example of something I did similar (in a stright table) to color the cells a specific color based on status

=(if(PRIORITY='Urgent',RGB(255,0,0), if(PRIORITY='Low',RGB(0,255,0), if(PRIORITY='Medium',RGB(255,255,0), if(PRIORITY='High',RGB(255,128,0))))))

[adiarnon]

But my dimention is calculated-

if(aggr((sum({<Rate_MonthYear={"$(v_early)"}>}MONTHLY_ON_TIME_UNITS_QTY)/sum({<Rate_MonthYear={"$(v_early)"}>}MONTHLY_RCVD_UNITS_QTY)),Central_BP)>=0.95,'Preferred',
if(aggr((sum({<Rate_MonthYear={"$(v_early)"}>}MONTHLY_ON_TIME_UNITS_QTY)/sum({<Rate_MonthYear={"$(v_early)"}>}MONTHLY_RCVD_UNITS_QTY)),Central_BP)>=0.85,'Satisfactory','Unsatisfactory'))

and i tried in the  background color of the expression-

if(aggr((sum({<Rate_MonthYear={"$(v_early)"}>}MONTHLY_ON_TIME_UNITS_QTY)/sum({<Rate_MonthYear={"$(v_early)"}>}MONTHLY_RCVD_UNITS_QTY)),Central_BP)>=0.95,RGB(255,0,0),

if(aggr((sum({<Rate_MonthYear={"$(v_early)"}>}MONTHLY_ON_TIME_UNITS_QTY)/sum({<Rate_MonthYear={"$(v_early)"}>}MONTHLY_RCVD_UNITS_QTY)),Central_BP)>=0.85,'RGB(255,128,0)',RGB(0,255,0))

but it stil not working

[krishna20]

Hi,

A sample app is much better to guide you in the right way.. Please post a sample app.

[lironbaram]

hi

i would try to us the aggr as the outside function something like

aggr(if((sum({<Rate_MonthYear={"$(v_early)"}>}MONTHLY_ON_TIME_UNITS_QTY)/sum({<Rate_MonthYear={"$(v_early)"}>}MONTHLY_RCVD_UNITS_QTY))>=0.95,RGB(255,0,0),

if((sum({<Rate_MonthYear={"$(v_early)"}>}MONTHLY_ON_TIME_UNITS_QTY)/sum({<Rate_MonthYear={"$(v_early)"}>}MONTHLY_RCVD_UNITS_QTY))>=0.85,RGB(255,128,0),RGB(0,255,0))),Central_BP)

[adiarnon]

its not working