Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
HirisH_V7
Master
Master

Bar Chart Color Based on the Condition

Hi Qlikers,

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

Bar Chart Half Color.PNG

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



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

Accepted Solutions
Gysbert_Wassenaar

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

View solution in original post

19 Replies
Gysbert_Wassenaar

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
HirisH_V7
Master
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,

Bar Chart Half Color-201170.PNG

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

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

hi

rename the expression to desired name.

it will display that name only

jagan
Luminary Alumni
Luminary Alumni

Hi,

PFA file for solution.

Regards,

jagan.

Anonymous
Not applicable

will this work?

HirisH_V7
Master
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!”
HirisH_V7
Master
Master
Author

Hi Balraj,

No its not as desired. As Explained above!

-Hirish

HirisH
“Aspire to Inspire before we Expire!”
jagan
Luminary Alumni
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.

HirisH_V7
Master
Master
Author

kindly Share the Attachement!

HirisH
“Aspire to Inspire before we Expire!”