Announcements
cancel
Showing results for
Did you mean:
Master

## Bar Chart Color Based on the Condition

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.

Hirish

HirisH
“Aspire to Inspire before we Expire!”
1 Solution

Accepted Solutions

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.

talk is cheap, supply exceeds demand
19 Replies

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.

talk is cheap, supply exceeds demand
Master
Author

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,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
Creator III

hi

rename the expression to desired name.

it will display that name only

Luminary Alumni

Hi,

PFA file for solution.

Regards,

jagan.

Anonymous
Not applicable

will this work?

Master
Author

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
“Aspire to Inspire before we Expire!”
Master
Author

Hi Balraj,

No its not as desired. As Explained above!

-Hirish

HirisH
“Aspire to Inspire before we Expire!”
Luminary Alumni

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.

Master
Author

kindly Share the Attachement!

HirisH
“Aspire to Inspire before we Expire!”
Community Browser