topic Re: Draw Reference Line in QlikView

Draw Reference Line

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

I have a linear chart, with months on the x-aixs and costs on the y-axis, like this:

Now I would draw a vertical line inside a linear graph, and this line should indicate the current month, like this:

I draw the red line with paint.

I can't use Reference Lines option, because on x-axis I don't have number, but string.

Someone can help me to find a solution?

Thanks

isorinrusu — Fri, 24 Nov 2017 10:18:17 GMT

Hi Andrea,

You won't be able to use vertical reference lines unless you use a continuous x-axis (found in axis, between the "axis colours" at the left).

Since you're using months, I think you could convert it to Date and then you'd be able to check the continous axis, thus enabling this option.

Regards,

Sorin.

avinashelite — Fri, 24 Nov 2017 10:27:13 GMT

Anonymous — Fri, 24 Nov 2017 11:41:42 GMT

I did what you said.

Now the x-axis values looks like this:

How can I show only the first day of the month, like this:

In this second image I disabled the continuous option, but in this case Reference Lines option doesn't work

stabben23 — Fri, 24 Nov 2017 12:59:54 GMT

Hi,

could you use a combo chart and add Expression like if(Months=vPreviousMonth, 150.00) and use bar?

woshua5550 — Fri, 24 Nov 2017 13:49:32 GMT

An error bar can almost do it , except a little bit garbages at the end of the line

plz find attachment , for your infomation

woshua5550 — Fri, 24 Nov 2017 14:13:34 GMT

continuous x-axis + reference line + text on axis will make perfect

PFA