topic Re: Bar Chart Color Based on the Condition in QlikView

Bar Chart Color Based on the Condition

HirisH_V7 — Sun, 24 Jan 2016 14:13:06 GMT

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

Re: Bar Chart Color Based on the Condition

Gysbert_Wassenaar — Sun, 24 Jan 2016 14:41:04 GMT

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.

Re: Bar Chart Color Based on the Condition

HirisH_V7 — Mon, 25 Jan 2016 05:25:36 GMT

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

Re: Bar Chart Color Based on the Condition

mightyqlikers — Mon, 25 Jan 2016 05:52:55 GMT

rename the expression to desired name.

it will display that name only

Re: Bar Chart Color Based on the Condition

jagan — Mon, 25 Jan 2016 05:55:51 GMT

Hi,

PFA file for solution.

Regards,

jagan.

Re: Bar Chart Color Based on the Condition

Anonymous — Mon, 25 Jan 2016 05:55:55 GMT

will this work?

Re: Bar Chart Color Based on the Condition

HirisH_V7 — Mon, 25 Jan 2016 06:07:50 GMT

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

Re: Bar Chart Color Based on the Condition

HirisH_V7 — Mon, 25 Jan 2016 06:10:06 GMT

Hi Balraj,

No its not as desired. As Explained above!

-Hirish

Re: Bar Chart Color Based on the Condition

jagan — Mon, 25 Jan 2016 06:53:52 GMT

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.

Re: Bar Chart Color Based on the Condition

HirisH_V7 — Mon, 25 Jan 2016 08:32:16 GMT

kindly Share the Attachement!

Re: Bar Chart Color Based on the Condition

jagan — Mon, 25 Jan 2016 08:46:25 GMT

PFA.

Re: Bar Chart Color Based on the Condition

HirisH_V7 — Mon, 25 Jan 2016 09:01:00 GMT

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

Re: Bar Chart Color Based on the Condition

jagan — Mon, 25 Jan 2016 09:07:10 GMT

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.

Re: Bar Chart Color Based on the Condition

HirisH_V7 — Mon, 25 Jan 2016 09:14:04 GMT

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

Re: Bar Chart Color Based on the Condition

jagan — Mon, 25 Jan 2016 09:17:55 GMT

Hi,

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

Re: Bar Chart Color Based on the Condition

HirisH_V7 — Mon, 25 Jan 2016 09:27:42 GMT

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

whats this issue ,

Help out,

Hirish

Re: Bar Chart Color Based on the Condition

tresB — Mon, 25 Jan 2016 09:33:47 GMT

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

Re: Bar Chart Color Based on the Condition

PradeepReddy — Mon, 25 Jan 2016 09:46:37 GMT

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

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

Re: Bar Chart Color Based on the Condition

HirisH_V7 — Mon, 25 Jan 2016 09:49:26 GMT

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

Re: Bar Chart Color Based on the Condition

susovan — Mon, 25 Jan 2016 09:57:28 GMT

Hi Hirish V,

Please check this attachment.