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

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

Fri, 06 Jun 2014 07:08:57 GMT

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.

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

Fri, 06 Jun 2014 07:55:33 GMT

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

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

arulsettu — Fri, 06 Jun 2014 08:19:55 GMT

hi try this

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

Jason_Michaelides — Fri, 06 Jun 2014 08:24:12 GMT

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...

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

Fri, 06 Jun 2014 08:46:05 GMT

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

Thanks,

Sahithya

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

Anonymous — Fri, 06 Jun 2014 08:51:29 GMT

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.

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

Fri, 06 Jun 2014 08:53:32 GMT

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

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

sujeetsingh — Fri, 06 Jun 2014 08:56:47 GMT

Use conditional presentation

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

manideep78 — Fri, 06 Jun 2014 09:07:09 GMT

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

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

Anonymous — Fri, 06 Jun 2014 09:13:58 GMT

Hi Sahana,

Check attachment,

Thanks

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

Fri, 06 Jun 2014 09:27:33 GMT

Hi thanks for the response.

This has been done manually by checking out where the lines meet and give the corresponding strik_price1.So can this be done without we specifying the value???because as you can see at 76 its wrong it doesn't cross the graph here at zero.

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

Jason_Michaelides — Fri, 06 Jun 2014 09:55:50 GMT

As I mentioned above, the maths to calculate the intersect of a curved line like this is pretty complex. Our resident genius/geek/OCD-guy Martin Mahler has solved this with a very long expression...!! He'll post it shortly!

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

simondachstr — Fri, 06 Jun 2014 09:57:02 GMT

Something like this maybe?

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

Fri, 06 Jun 2014 10:11:59 GMT

oh my God!!!!

Martin your a genius.!!!!!!!!!!!!!!!

thanks a lotttttttttt it works

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

Fri, 06 Jun 2014 12:26:14 GMT

Awesome Martin

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

Mon, 09 Jun 2014 06:18:22 GMT

Hi Martin,

I have done few editing in the expression keeping the same concept how ever you had solved,but not able to get the correct lines.Please can you look into this and help me out one more time.... please?????????????????????

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

Mon, 09 Jun 2014 07:07:42 GMT

Hi Martin,

In the solution you provided on friday,for few conditions the ref lines are not working please can you help me out checking that why it doesn't happen for these options.

I have selected the conditions for which it is not showing the reference lines.Please check in the file attached.

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

simondachstr — Mon, 09 Jun 2014 07:40:51 GMT

The function I provided to you gives you the reference lines if your callput/strikeprice curve is a positive parable. The selection you made is a negative parable. A quick fix would be to add 2 additional reference lines with the same formulas, but max<>min and above<>below switched up.

Try it yourself first - I will only have time this evening to fix it.

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

simondachstr — Mon, 09 Jun 2014 08:00:23 GMT

That was quicker to fix than expected - see attached and let me know.

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

Mon, 09 Jun 2014 08:17:20 GMT

Hi ,

Thanks a lot Martin,for your precious time and response .

Yes ,this helped.So by replacing '>0' it works right ?? ok, new learning for me .

I was actually changing the min/max and above/below as well which dint work..

Actually I have another doubt which I have attached above,anyways I will attach it again here,ones you become free please help me out.

Its the same but my net expression is different which has to be taken to get these reference line exp.I am trying it out,but somewhere its going wrong in the replacements .

Please help ones your free,till then I will try out and wish I solve it.