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

Trying to add a Reference line on x-axis

Mon, 21 Oct 2013 08:49:06 GMT

Hi,

I have a simple bar chart with an x-axis based on month/year, formatted to YY-MMM. I'm trying to set defined reference line break-points in the x-axis of the chart such as 14-APR, 14-SEP and so on - but can't get it to work. I've set the x-axis to be continuous and tried to set the reference line expression to every format I can think of. But whatever I try the reference line doesn't appear.

I'm guessing this is a formatting issue, can someone point me in the right direction?

Thanks

Nick

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

tresB — Mon, 21 Oct 2013 09:13:16 GMT

Could you post a sample?

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

senpradip007 — Mon, 21 Oct 2013 09:22:10 GMT

Please upload a sample application.

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

Mon, 21 Oct 2013 09:49:48 GMT

Hi,

I've enclosed the example chart. Reference expression is wrong at the moment, I want my reference line to appear on the x-axis at the point of my choosing such as 31-March-2013 and so on...

Thanks!

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

Mon, 21 Oct 2013 10:51:55 GMT

Hi,

Sample application uploaded for you. Appreciate any ideas. Thanks.

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

Anonymous — Mon, 21 Oct 2013 11:10:48 GMT

Nick

For your reference line use an expression like :

date(date#('14-Mar','YY-MMM') )

Making sure the reference line Location is set to Continuous X.

Best Regards, Bill

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

Mon, 21 Oct 2013 11:15:38 GMT

you want vertical reference lines?

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

Mon, 21 Oct 2013 11:19:49 GMT

That's worked perfectly - thank you!