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

[jagan]

PFA.

[HirisH_V7]

Hi jagan,

The Percentage is 50% Right but its been at the bottom,It should be as per the right side axes on top of the bars.

-Hirish

[jagan]

Hi,

Yes this is what in the attached file.   Check the Axes for all the expressions, for % it should be right for the remaining expressions it should be Left.

Regards,

Jagan.

[HirisH_V7]

Where as ,50 % value is showing on 0% line on the axes. please help out with that.it should be on top at 50% as of axes.

-Hirish

[jagan]

Hi,

I am seeing the line at 50% .  Check the image below.

[HirisH_V7]

As  here it is like this,what i m seeing on Same QVW as you shared with me.

whats this issue ,

Help out,

Hirish

[tresesco]

Change the axis position : Right(Top) for % expression and for rest all Left (Bottom).

[PradeepReddy]

(sum(sales)/2)/Sum(Sales) will give always '1/2'.

u can take a reference line also,  or u want only the expression?

[HirisH_V7]

Hi,

Its same selected for the axes ,But its displaying like that,

In QV 11 on test its working fine,

But on QV 12 its displaying like this.

Help on this!!

PFA,

Hirish

[susovan]

Hi Hirish V,

Please check this attachment.