topic Re: Bar Chart Color as Per Dimension in QlikView

Bar Chart Color as Per Dimension

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

Hello,

One more help please:

I have simple bar chart Year vs Total Customer. I'm restricting Years for latest 2 years. So it is showing 2017, 2018 Total Customer data.

Now I want to show max(Year) in one color and max(Year)-1 in other. I've added background color in expression and it is working with Year filter selected.

But when I clear all the filters both the bars are of same color. Only this is working when Year filter selected. Screenshots attached.

Can you please help me on this?

Thank You in advance !

Message was edited by: Amruta Joshi

Re: Bar Chart Color as Per Dimension

trdandamudi — Tue, 02 Oct 2018 12:41:42 GMT

Can you share a sample qvw?

Re: Bar Chart Color as Per Dimension

Anil_Babu_Samineni — Wed, 03 Oct 2018 06:46:57 GMT

You can use condition based, then?

If(GetSelectedCount(Year)=0, Your Condition, Your Condition)

Re: Bar Chart Color as Per Dimension

amruta_j — Wed, 03 Oct 2018 08:57:29 GMT

Not working ...:(

Re: Bar Chart Color as Per Dimension

jyothish8807 — Wed, 03 Oct 2018 09:20:52 GMT

Hi Amruth,

Store max(Year) in a variable and try the same expression.

MaxYear= max(Year)

Background exp: if(Year=$(MaxYear),RGB(192,0,0), RGB(248,203,173))

Pfa

Br,

Re: Bar Chart Color as Per Dimension

amruta_j — Fri, 05 Oct 2018 01:34:46 GMT

thank you..it worked.

But not sure why without variable it was not working.

Re: Bar Chart Color as Per Dimension

jyothish8807 — Sat, 06 Oct 2018 03:25:08 GMT

Since you where using Max(date) for each date in dimension it becomes max date itself, so always the first condition becomes correct and it dosent go to 2nd condition.

Br,