topic Re: persistent color pie chart in QlikView

persistent color pie chart

adiarnon — Mon, 12 Oct 2015 11:39:04 GMT

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

Re: persistent color pie chart

Gysbert_Wassenaar — Mon, 12 Oct 2015 11:53:42 GMT

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?

Re: persistent color pie chart

adiarnon — Mon, 12 Oct 2015 12:05:50 GMT

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?

Re: persistent color pie chart

Mon, 12 Oct 2015 12:21:48 GMT

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)

Re: persistent color pie chart

adiarnon — Mon, 12 Oct 2015 12:41:33 GMT

hi tnx

but,

i tried and its not working...

the color chainging by th edimention and not by the expression

adi

Re: persistent color pie chart

Mon, 12 Oct 2015 12:50:24 GMT

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

Re: persistent color pie chart

adiarnon — Wed, 14 Oct 2015 04:26:06 GMT

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

Re: persistent color pie chart

krishna20 — Wed, 14 Oct 2015 05:54:50 GMT

Hi,

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

Re: persistent color pie chart

lironbaram — Wed, 14 Oct 2015 06:01:05 GMT

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)

Re: persistent color pie chart

adiarnon — Wed, 14 Oct 2015 06:56:23 GMT

its not working

Re: persistent color pie chart

lironbaram — Wed, 14 Oct 2015 07:28:14 GMT

does v_early variable is changed according to selections ?

i tried a similar approach in a simple model and it works well

i used this formula in the dimension

=aggr(if(sum(Sales)<40000,'Low',if(sum(Sales)>70000,'High','Medium')),ID),

this expression

count(ID)

and this in the background of the expression

=aggr(if(sum(Sales)<40000,Green(),if(sum(Sales)>70000,Red(),Yellow())),ID)

so it's either something change the dimension values or the coloring values