PIE Chart

adiarnon — Mon, 31 Aug 2015 06:22:42 GMT

hi,

i have a pie chart -

the dimansion is expression-

=if(aggr(((sum(MONTHLY_RCVD_UNITS_QTY_NEW)-sum(MONTHLY_RJCT_MRB_SI))/sum(MONTHLY_RCVD_UNITS_QTY_NEW)),Central_BP)>=0.95,'Preferred',
if(aggr(((sum(MONTHLY_RCVD_UNITS_QTY_NEW)-sum(MONTHLY_RJCT_MRB_SI))/sum(MONTHLY_RCVD_UNITS_QTY_NEW)),Central_BP)>=0.85,'Satisfactory','Unsatisfactory'))

the expression-

count(distinct bp_code)

i want that each value of my dimension will hava a color anf if im choosing ine value the color will stay

i try to do it with presistent color ant its not work

how can i do it?

tnx,

adi

Re: PIE Chart

gautik92 — Mon, 31 Aug 2015 06:27:54 GMT

it should work with persistent color

Re: PIE Chart

Digvijay_Singh — Mon, 31 Aug 2015 06:40:05 GMT

Try like this -

To get consistent colors for same options

topic Re: PIE Chart in QlikView

PIE Chart

Re: PIE Chart

Re: PIE Chart