Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
HirisH_V7
Honored Contributor

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
MVP & Luminary
MVP & Luminary

Re: Bar Chart Color Based on the Condition

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
MVP & Luminary
MVP & Luminary

Re: Bar Chart Color Based on the Condition

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

HirisH_V7
Honored Contributor

Re: Bar Chart Color Based on the Condition

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
Contributor III

Re: Bar Chart Color Based on the Condition

hi

rename the expression to desired name.

it will display that name only

MVP & Luminary
MVP & Luminary

Re: Bar Chart Color Based on the Condition

Hi,

PFA file for solution.

Regards,

jagan.

balrajahlawat
Esteemed Contributor

Re: Bar Chart Color Based on the Condition

will this work?

HirisH_V7
Honored Contributor

Re: Bar Chart Color Based on the Condition

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
Honored Contributor

Re: Bar Chart Color Based on the Condition

Hi Balraj,

No its not as desired. As Explained above!

-Hirish

HirisH
“Aspire to Inspire before we Expire!”
MVP & Luminary
MVP & Luminary

Re: Bar Chart Color Based on the Condition

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
Honored Contributor

Re: Bar Chart Color Based on the Condition

kindly Share the Attachement!

HirisH
“Aspire to Inspire before we Expire!”