topic Re: Adding an Average reference line to a bar chart in QlikView

Adding an Average reference line to a bar chart

Tue, 05 Mar 2013 06:35:24 GMT

Hi,

I need to create a similar chart like the one attached.

The issue I have is displaying a vertical line which indicates the average duration value.

I found in the forums tips about using a reference line. But the issue is that it is horizontal.

Your help is highly appreciated.

Thanks!

Tue, 05 Mar 2013 08:30:38 GMT

Gysbert_Wassenaar — Tue, 05 Mar 2013 08:53:33 GMT

The x-axis needs to be continuous to make it possible to add a vertical reference line. See attached example.

Tue, 05 Mar 2013 10:29:38 GMT

Hi,

I can't open your file, because I have a personal edition.

But after definining the Continuous, it's still didn't help.

BTW, I'm using Class for the dimension, but it was overriden by the Continuos.

Thanks!

Gysbert_Wassenaar — Tue, 05 Mar 2013 10:34:57 GMT

If you have continuous X axis you can add a vertical reference line by choosing Continous X as location:

Tue, 05 Mar 2013 10:52:32 GMT

Now I got it! Thanks!

The only issue left is that I can't use the class display range.

(If I disselect the Continuous from the Axes tab).

Is there a workaround to have both?