topic Reference Line in QlikView

Reference Line

Fri, 13 Jun 2014 10:44:53 GMT

Is it possible to draw a reference line on only one of the two bar with in a single bar graph

for more understanding see the below image

i want to draw 2 reference line in below 1st graph but once i draw the it cover both the graph , but user want that the one bottom shud only cover green bar means it range don't cross green bar & top line should start from orange bar graph and end at end of the orange bar

Re: Reference Line

Gysbert_Wassenaar — Fri, 13 Jun 2014 10:54:02 GMT

The only way to do that is by creating Line objects and position them where you want them. Those Line object naturally will not respond to any selections. So they won't change position if the bars in your chart change.

Re: Reference Line

ashfaq_haseeb — Fri, 13 Jun 2014 10:55:03 GMT

Hi look at the below posts.

Reference Line in Chart

Re: Trying to add a Reference line on x-axis

Regards

ASHFAQ

Re: Reference Line

sujeetsingh — Fri, 13 Jun 2014 10:55:59 GMT

Add reference Line on presentation tab and you have to provide the logic you want the lines to follow..

..there should be the values where these lines need to be drawn

Re: Reference Line

sujeetsingh — Fri, 13 Jun 2014 10:56:42 GMT

Gysbert have suggested a good way

Re: Reference Line

dharmarasu — Fri, 13 Jun 2014 11:01:39 GMT

hi Shweta,

To achieve that you want write expression in reference line is as same as in First Bag expression..

Dharma.

Re: Reference Line

Mon, 16 Jun 2014 05:07:25 GMT

it will not work

Re: Reference Line

Mon, 16 Jun 2014 05:08:42 GMT

Is there is any other to draw a reference line which only width of the bar

Re: Reference Line

Mon, 16 Jun 2014 05:10:40 GMT

how we can calculate the width of the single bar in a bar chart

Re: Reference Line

dharmarasu — Mon, 16 Jun 2014 05:45:55 GMT

Can u share the App.

Re: Re: Reference Line

dharmarasu — Mon, 16 Jun 2014 06:32:58 GMT

In reference line u can write your own expression which u want to be show.

for an example.

=Sum({<your dimension={[First Bag]>}[First Bag])

see the attached app.

Hope this helps...

Re: Reference Line

Mon, 16 Jun 2014 07:25:48 GMT

thats not my requirement ,just a an example of your application a test data, i want to draw 3 different line reference on each bar graph and it should start and end to the width of the garph