Bar Chart Color Based on the Condition

[HirisH_V7]

Hi Qlikers,

I want to Fill a Color in Bar Chart Based on Conditional,

Here in the Bar Chart image with ,

One Dimension - YearMonth

Expressions: 1.Sum(Sales)

                    2.Sum(Sales)/2

In the Second Expression Bar, i need to include Sum(Quantity) as Green Color. Means For example in Jan-14  Value is '1381164' as its showing red .In that bar itself  till Sum(Quantity) Value '8,380' it should be in green.

Thanks in advance,

Hirish

[Gysbert_Wassenaar · Accepted solution]

8,380 is less then 0.1% of 1,3811,164 so you won't be able to any green in the red bar. To demonstrate the technique I divided the sales by 100. See attached example.

[HirisH_V7]

Hi,

Here in the above chart it self i need to add relative Percentage of two bars as line,I mentioned as another Expression But its displaying at the bottom of the chart as highlighted,

And As i mouse over on the chart its showing complete Expression as above ,How to avoid it , I want to see only numbers for color associated and on the Second bar i want to get the total of the two colors when i hover at top is this possible.

PFA,

Thanks in Advance,

Hirish

[mightyqlikers]

hi

rename the expression to desired name.

it will display that name only

[jagan]

Hi,

PFA file for solution.

Regards,

jagan.

[Anonymous]

will this work?

[HirisH_V7]

Hi jagan,

There at Fourth expression if i Kept Values on the data points the figures are shows as 50% , But its displayed at the bottom of the Chart where its not shown with respect to axes.

-Hirish

[HirisH_V7]

Hi Balraj,

No its not as desired. As Explained above!

-Hirish

[jagan]

Hi,

You have selected % and Sum(Sales)/2 as Right Axes in Axes, Sum(Sales)/2 is having a huge number when compared to %, so give Right Axes only %, this will fix.  Refer attached file.

Regards,

Jagan.

[HirisH_V7]

kindly Share the Attachement!