topic Re: Expression background color in QlikView

Expression background color

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

Hi Experts - In the attached qvw... i have an Drill down as Dimension...

In the chart... For the "Aging" the bar should appear as Red color and for "Non Aging" Bar color should be Green..

While we click on "Aging" (as it is Drill down), i need the next 3 bars in 3 different color (any color) ...

and same logic while clicking on "Non Aging" as well..

I tried with If condition .. but not coming as expected.. Plz Help..

Re: Expression background color

Anil_Babu_Samineni — Wed, 13 Sep 2017 07:07:43 GMT

May be enable option "Multicolored" in colors tab?

Re: Expression background color

bharani8 — Wed, 13 Sep 2017 07:11:25 GMT

Hi Anil - That will work... But in my DB... if i click on that "Non Aging" .. i need 3 different Green in the next chart (that appears from my Drill down Dimension) and same way... when i click on "Aging".. 3 different red color should appear in the next view of that..

Re: Expression background color

Anil_Babu_Samineni — Wed, 13 Sep 2017 07:19:04 GMT

As i thought, It should this for BG color. PFA

If(GetCurrentField([Aging_DD]) = 'Aging_Bucket1', Green())

Re: Expression background color

bharani8 — Wed, 13 Sep 2017 07:43:24 GMT

I have used the below in my Background color in Expression.. Still.. 61-90 bucket i dont see it is getting reflected to Yellow

if (Aging_Bucket2 = 'Non Aging' ,RGB(77,167,65),

if(Aging_Bucket2 = 'Aging',RGB(255,0,0),

if (Aging_Bucket1 = '>365' , RGB(255,0,0),

if (Aging_Bucket1 = '181-365', RGB(250,70,70),

if (Aging_Bucket1 = '91-180', RGB(252,115,98),

if (Aging_Bucket = '>90' , RGB(255,0,0),

if (Aging_Bucket1 = '61-90' or Aging_Bucket = '61-90', RGB(255,255,0),

if (Aging_Bucket1 = '31-60' or Aging_Bucket = '31-60', RGB(77,167,65),

if (Aging_Bucket1 = '0-30' or Aging_Bucket = '0-30', RGB(77,200,65))))))))))

Re: Expression background color

techvarun — Wed, 13 Sep 2017 07:49:07 GMT

Is Aging_Bucket a valid field? Its not available in your sample app

Re: Expression background color

bharani8 — Wed, 13 Sep 2017 07:51:19 GMT

You are Right.. Ignore that field... Apologies for the confusion

Re: Expression background color

bharani8 — Wed, 13 Sep 2017 07:52:15 GMT

My Requirement is simple...

if i click on that "Non Aging" .. i need 3 different Green in the next chart (that appears from my Drill down Dimension) and same way... when i click on "Aging".. 3 different red color should appear in the next view of that..

Re: Expression background color

Anil_Babu_Samineni — Wed, 13 Sep 2017 08:03:59 GMT

Have you check my file? Does this not helpful to you?

Re: Expression background color

bharani8 — Wed, 13 Sep 2017 08:06:50 GMT

No Anil... My requirement is diff..

"Non Aging" should be Green color and "Aging" should be Red color

Re: Expression background color

Anil_Babu_Samineni — Wed, 13 Sep 2017 08:14:31 GMT

Like this?

Note : Please mark it as helpful and that link up to helpers...

Re: Expression background color

Anil_Babu_Samineni — Wed, 13 Sep 2017 08:15:13 GMT

I used this, If you don't have license

If(Match(Aging_Bucket2, 'Aging') and GetCurrentField([Aging_DD]) = 'Aging_Bucket1', Green(),

If(Match(Aging_Bucket2, 'Non Aging') and GetCurrentField([Aging_DD]) = 'Aging_Bucket1', Red(),

))

Re: Expression background color

bharani8 — Wed, 13 Sep 2017 08:17:21 GMT

But Aging and Non Agng Bars i see in Blue itself...cant we change that to Red and Green?

Re: Expression background color

Anil_Babu_Samineni — Wed, 13 Sep 2017 08:23:00 GMT

Why not?

Re: Expression background color

bharani8 — Wed, 13 Sep 2017 08:25:14 GMT

Perfect... Now in that "61-90" bucket alone i need to be in yellow.. Is that possible ? Rest all should be same..

Re: Expression background color

Anil_Babu_Samineni — Wed, 13 Sep 2017 08:27:12 GMT

You can write if(..else....elseif...)

If(Match(Aging_Bucket2, 'Aging') and GetCurrentField([Aging_DD]) = 'Aging_Bucket1', Green(),

If(Match(Aging_Bucket2, 'Non Aging') and GetCurrentField([Aging_DD]) = 'Aging_Bucket1', Red(), Yellow()

))

Re: Expression background color

bharani8 — Wed, 13 Sep 2017 08:30:45 GMT

Not Working... Now i see Aging and Non Aging Bars in Yellow

Re: Expression background color

techvarun — Wed, 13 Sep 2017 08:51:38 GMT

Check the attached,

Re: Expression background color

Anil_Babu_Samineni — Wed, 13 Sep 2017 08:52:06 GMT

My Bad? PFA..

Re: Expression background color

techvarun — Wed, 13 Sep 2017 08:54:24 GMT