Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

need reference lines for 0 line value in chart??? how do we do it?? need help please.

Hi all,

I have a graph as shown in the file attached.I need a horizontal line representing the '0' of y axis and also where ever the graph cuts the zero line I need vertical lines representing the corresponding x axis values.

Is this possible.Please require help.

I have attached my qv file as well s the image to clarify the requirement.

27 Replies
Not applicable
Author

Can anyone help me out with above requirement  please?????

arulsettu
Master III
Master III

hi try this

Capture1.PNG.png

Jason_Michaelides
Partner - Master II
Partner - Master II

Horizontal line is easy - just use a reference line on the primary Y axis (will become clear in the properties Presentation > Add...)

Vertical lines at the intersect of x=0 is mathematically rather more tricky...

Not applicable
Author

Go to Properties->Axes, enable Log scale and set the width to 1 to get reference line for 0.image.JPG

Thanks,

Sahithya

Anonymous
Not applicable
Author

Hi Sahana,

You can follow these steps:

>> Go to chart properties

>> Presentation

>> Reference Lines

Here you can add as many expressions as you need in your application. You should give correct expression. You can also select appropriate color according to the requirements.

I'm attaching your application with the required modifications as u mentioned. Do let me know whether it was helpful.

Have a nice day.

Not applicable
Author

hi Sahithya,

that was great thanks a lot!!!!!

do you know how to plot the vertical references as well where ever the graph is cutting the zero line????

I am trying out the reference line formula but just not working

sujeetsingh
Master III
Master III

Use conditional presentation

manideep78
Partner - Specialist
Partner - Specialist

Hi

Go to Axes tab, Check continuous option in Dimesion Axes.

Go to Presentation tab, add reference line '0' and check the option 'Secondary Y'.

That gives you vertical reference line.

Hope this helps

Thanks & Regards

Manideep

Anonymous
Not applicable
Author

Hi Sahana,

Check attachment,

vertical_line.PNG.png

Thanks