topic Re: Background Color in QlikView

Background Color

paulwalker — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have developed one chart ..

How to give bubble color..

Suppose I have 2 expressions..

Dimension: Customer

1. Sum(sales)/Sum(Total Amout)

2. Sum(revenue)

Suppose if

Donna Mitchell 0-50 % = red

51-60% Green

61-100% Yellow

How to assign colors??

Thanks...

Re: Background Color

Chanty4u — Mon, 04 Apr 2016 05:59:57 GMT

=if(client='[Donna Mitchell]' ,0-50% Red() and 51-60% Green(),Yellow())

Re: Background Color

paulwalker — Mon, 04 Apr 2016 06:05:47 GMT

I have to give Percentage wise colors

Suppose

Client= 'A', 0-50%, red

Client='A', 51-60%, green..

Client='A', 61-100%, Yellow

Thanks in Advance

Re: Background Color

amayuresh — Mon, 04 Apr 2016 06:07:38 GMT

Is percentage is varying from Client to Client or same for all Client ?

Re: Background Color

Kushal_Chawda — Mon, 04 Apr 2016 06:07:41 GMT

Click on + sign of expression Sum(sales)/Sum(Total Amout) , put below expression in background color

=if((Sum(sales)/Sum(Total Amout))>= 0 and (Sum(sales)/Sum(Total Amout)) <= 0.5, red(),

if((Sum(sales)/Sum(Total Amout))> 0.5 and (Sum(sales)/Sum(Total Amout)) <= 0.6, green(),

if((Sum(sales)/Sum(Total Amout))> 0.6 and (Sum(sales)/Sum(Total Amout)) <= 1, Yellow())))

Re: Background Color

paulwalker — Mon, 04 Apr 2016 06:21:27 GMT

Thanks for Quick response.

1. Dimension (Customer)

Expressions(Sum(sales)/Sum(Total Amout) and Sum(revenue))

Client dimension I am not using in Chart..

I have written like this..

=if(CLient='A'>= 0 and Client='A' <= 0.5, red(),
if(Client='A'> 0.5 and Client=A'<= 0.6, green(),
if(Client='A'> 0.6 and Client='A' <= 1, Yellow()))),

if(CLient='B'>= 0.2 and Client='B' <= 0.6, red(),
if(Client='B'> 0.6 and Client=B'<= 0.8, green(),
if(Client='B'> 0.8 and Client='B' <= 1, Yellow())))

But it's not working .... Anything wrong here ??

Re: Background Color

Kushal_Chawda — Mon, 04 Apr 2016 06:25:27 GMT

try this

if(aggr(Sum(sales)/Sum(Total Amout),Client)>= 0 and aggr(Sum(sales)/Sum(Total Amout),Client) <= 0.5, red(),

if(aggr(Sum(sales)/Sum(Total Amout),Client)> 0.5 and aggr(Sum(sales)/Sum(Total Amout),Client)<= 0.6, green(),

if(aggr(Sum(sales)/Sum(Total Amout),Client)> 0.6 and aggr(Sum(sales)/Sum(Total Amout),Client) <= 1, Yellow())))

Re: Background Color

Chanty4u — Mon, 04 Apr 2016 06:26:15 GMT

what it is showng?

I think there is less values....so its not showng exctly?

Re: Background Color

paulwalker — Mon, 04 Apr 2016 06:32:14 GMT

Hi Kush,

I have different percentages for colors.

Client=A, (0-50,51-60,61-100)

Client=B (40-50, 51-65, 66-100)

Thanks ,...

Re: Background Color

paulwalker — Mon, 04 Apr 2016 07:24:13 GMT

Any possibility???

Re: Background Color

t_chetirbok — Mon, 04 Apr 2016 07:33:28 GMT

Hi!

Are your fields Customer and Client have relation 1 to 1?

for example if data is:

Customer Client sales

A A 100

A B 200

for Client A color is red(), for Client B color is green()

if you don't use Client as dimension, what color do you need?

Re: Background Color

paulwalker — Mon, 04 Apr 2016 17:43:19 GMT

Sorry for the delay..

Yes, I have mapping.. customer to client

for example

Customer Client sales

A A 100

A B 200

B A 1200

B B 250

Suppose if Client=A (0-50 Red, 51-60 Green, 61-100 Yellow)

If Client=B (0-45 Red, 46-70 Green, 71-100 Yellow)

and If client='Remaining' (what if i have C,D=== 0-30 Red, 31-60 Yellow, 61-100 Green)

Hope you understand.....

Thanks ....

Re: Background Color

paulwalker — Mon, 04 Apr 2016 18:24:19 GMT

is this possible????

Re: Background Color

rudolfhbantim — Mon, 04 Apr 2016 18:40:43 GMT

if you have tree filds, like red, green and yellow mapping with your client A, for exemple:

red = ‘>=0<=50’

green = ‘>=51<=60’

yellow = ‘>=61<=100

if(aggr(Sum(sales)/Sum(Total Amout),Client) = $(=Red), red(),

if(aggr(Sum(sales)/Sum(Total Amout),Client) = $(=green), green(),

if(aggr(Sum(sales)/Sum(Total Amout),Client) = $(=yellow),yellow() )))

i think it can work.

Re: Background Color

paulwalker — Tue, 05 Apr 2016 02:10:59 GMT

I don't have any tree field..

I am using Scatter chart..

Depends on Expression, i am getting percentage...

Here my client=ABC=58%

Client=ABC= 0-50% RED

51-60% Green and

61-100% Yellow

Client=ACD different color code

like (0-30 Red, 31-60 Green, 61-80 Yellow, 81-100 pink)

for Client=ABC=58%, My bubble it should be Green color, only contribution wise.....

I have to write Client=ABC one color code

Client=ACD one color code..

How to write for different color codes????

PFA,

Re: Background Color

paulwalker — Tue, 05 Apr 2016 03:51:37 GMT

Any possibility like this percentage wise color coding ??

Thanks...

Re: Background Color

settu_periasamy — Tue, 05 Apr 2016 04:38:27 GMT

You can try like below (in the target expression -> Background Color) - like wise you change the color based on your client

Check the Attachment

Re: Background Color

paulwalker — Tue, 05 Apr 2016 04:57:12 GMT

Hi Settu,

Almost there.. I have many attributes..

Example:

Client

ABC

ACD

ACC

ABB

ADD

KLM

OMN

Here my client=ABC=58%

Client=ABC= 0-50% RED

51-60% Green and

61-100% Yellow

Client=ACD different color code

like (0-30 Red, 31-60 Green, 61-80 Yellow, 81-100 pink)

Remaining are (ACC,ABB,ADD,KLM,OMN) 0-40 Red, 41-60 Blue, 61-80 Yellow, 81-100 Green

Thanks...

Re: Background Color

settu_periasamy — Tue, 05 Apr 2016 05:06:47 GMT

Try this..

=if(Client='ABC',
      if(sum(Contribution)>0.6 and sum(Contribution)<=1,
           Yellow(),
           if(sum(Contribution)>0.5 and sum(Contribution)<=0.6,
                Green(),
                if(sum(Contribution)>=0,
                     Red()))),
if(Client='ACD',
      if(sum(Contribution)>0.8 and sum(Contribution)<=1,
           Color(2), //write the pink color code using RGB()
           if(sum(Contribution)>0.6 and sum(Contribution)<=0.8,
           Yellow(),
                if(sum(Contribution)>0.3 and sum(Contribution)<=0.6,
                     Green()))),
      if(sum(Contribution)>0.8 and sum(Contribution)<=1,
           Green(),
           if(sum(Contribution)>0.6 and sum(Contribution)<=0.8,
                Yellow(),
                if(sum(Contribution)>0.4 and sum(Contribution)<=0.6,
                     Blue(),
                     if(sum(Contribution)>0 and sum(Contribution)<=0.4,
                     Red()))))))

Re: Background Color

paulwalker — Tue, 05 Apr 2016 07:48:02 GMT

Thanks Settu.....