topic Re: Help on Reference Lines in QlikView

Help on Reference Lines

Tue, 03 Feb 2015 16:39:06 GMT

Hi! I'm new to Qlikview and still learning the ropes. I have a bar chart with a dimension and a expression. The dimension includes only two categories on the x-axis, so two bars. I would like to add reference lines for each of the two bars. The reference line would refer to another amount that is relative to the category on the x-axis.The two reference lines will be on different levels due to the varying amounts.

Let's say the dimension is pets and the two bars are a dog and a cat. The bar represents the sum of the height of each type of pet. I would like the reference line to represent the sum of the weight of each type of pet. Terrible example, but I hope you get the point. I would appreciate your help on this. Thanks!

Re: Help on Reference Lines

jpenuliar — Tue, 03 Feb 2015 16:49:29 GMT

Reference line canbe added at Property>>Presentation>>Reference Line Section.

Click Add>> a dialog will appear o define your Expression and Label properties

Re: Help on Reference Lines

Tue, 03 Feb 2015 16:52:54 GMT

Yes, I tried that, but the reference lines are not appearing. I read that you have to use the Continuous X option, but it's grayed out.

Re: Help on Reference Lines

jpenuliar — Tue, 03 Feb 2015 16:57:06 GMT

Your Reference line Values can be miniscule to appear in your chart, This happens if your Dimensions are in Thousands and your Reference is little value, you might find it at the bottom of the grid.

try a Straight Table Chart fast change just to verify your Reference Values

Re: Help on Reference Lines

jpenuliar — Tue, 03 Feb 2015 16:59:00 GMT

Try and atatched a sample file, so the community might be able to help you quicker by example

Re: Help on Reference Lines

Tue, 03 Feb 2015 17:17:25 GMT

Thanks for the help Johnathan. The info on my file is bit confidential, but I can provide a sample file if necessary.

The reference line amounts are nearly equivalent to the bar values. They are in the tens of millions and are 1-2 million dollars off. Any other issues that you foresee?

Re: Help on Reference Lines

jpenuliar — Tue, 03 Feb 2015 17:24:36 GMT

Can you try a defined single value of lets say, +1 million of the value of your first Bar/Category.

I suspect the expression logic you put in your Reference is doing the trick.

My understanding to a Reference line is it is a Straight Ref Line, therefore a single value for all Bars and not changing.

What is the result of your reference Line Values if you view in straight Table?

Re: Help on Reference Lines

Tue, 03 Feb 2015 18:01:34 GMT

Hi Johnathan, your tips did help, But, it only creates a single straight line. I would like the bar graph to look like this

Each reference line per bar. Thanks for the help so far!

Re: Help on Reference Lines

jpenuliar — Wed, 04 Feb 2015 09:29:50 GMT

I suppose you can add two Ref Lines(diff colors), 1 for each Bar as a workaround to your problem.

Re: Help on Reference Lines

Wed, 04 Feb 2015 10:41:31 GMT

Please refer the Discussion, This may help you.

how to split reference line?