topic Re: Different color for a bar based on Reference Value in QlikView

Different color for a bar based on Reference Value

Fri, 26 Apr 2013 05:45:11 GMT

HI everyone,

I have a requirement that in Bar chart i am using Reference line, so i want one color above the reference line and other color below the reference. I have attached the sample scrren shot, in which 25 is the value indicating the Reference line, i want different color above that 25 value reference line. Iam using Qv 9 sr7, how can i achieve dis.

Thanx in Advance

Nikitha Jain

Re: Different color for a bar based on Reference Value

Gysbert_Wassenaar — Fri, 26 Apr 2013 08:47:12 GMT

See attached qvw.

Re: Different color for a bar based on Reference Value

Fri, 26 Apr 2013 08:55:07 GMT

Hi Nikitha,

Please find the attached qvw.

In my example,I have used the reference value as 7.

Regards,

Snehal Nabar

Re: Different color for a bar based on Reference Value

Fri, 26 Apr 2013 09:09:50 GMT

Thank u very much. It worked ..

Re: Different color for a bar based on Reference Value

sujeetsingh — Fri, 26 Apr 2013 09:31:32 GMT

Gysbert,

I am not able to grap the requirement of your qvw.

please explain.

Re: Different color for a bar based on Reference Value

Fri, 26 Apr 2013 09:41:39 GMT

hi Gysbert,

The color is working fine but the value on the bar is not available though 'value on data point' is checked. so i want the value to be displayed on each bar. can u pls suggest abt this

i Have attached the screenshot.

Thanks in advance,

Nikitha

Re: Different color for a bar based on Reference Value

Gysbert_Wassenaar — Fri, 26 Apr 2013 11:05:04 GMT

On the Expression tab enable Values on Data Points only for the second expression.

Re: Different color for a bar based on Reference Value

Mon, 29 Apr 2013 06:19:50 GMT

Thank u very much Gysbert, nw i am getting exactly what i want.

Re: Different color for a bar based on Reference Value

Thu, 02 May 2013 05:20:07 GMT

Hi Gysbert,

I hve attached one screenshot, In that every month has 2 bars Representing sales nd service respectively. if i want different color above the reference line seperately hw can do this. If i try to put the expressions wat u hve attached and stacked i am getting al in one bar only. i want sales1 nd sales2 as one bar service1 nd service2 as other bar.

Thanks in Advance,

Nikitha