Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

Trying to add a Reference line on x-axis


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

Tags (1)
1 Solution

Accepted Solutions
Highlighted

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

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

View solution in original post

7 Replies
Highlighted
MVP
MVP

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

Could you post a sample?

Highlighted
senpradip007
Valued Contributor III

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

Please upload a sample application.

Highlighted
Not applicable

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

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!

Highlighted
Not applicable

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

Hi,

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

Highlighted

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

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

View solution in original post

Highlighted
Not applicable

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

you want vertical reference lines?

Highlighted
Not applicable

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

That's worked perfectly - thank you!