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

[#1]

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.

[simondachstr]

I think you need to include the vOption variable in the reference line expressions..

[#3]

hi,

I have used the $(voption) in the expression even after which it doesn't work.My latest trial is attached.you can have a look.

[#4]

Hi Martin,

Were you able to find where I am going wrong???

I am stuck with the same and trying out but somehow still not able to get the perfect reference.

[simondachstr]

I'll have a look at it in the evening.

[simondachstr]

I strongly suggest to you to prepone most of those calculations/logic to the qlikview script. Just by looking at the formulas and without knowing the business, it would take me ages to figure out where the issue is. Plus, as you can see, the loading time of the chart has risen significantly.The vertical reference lines are working in a simple case, as demonstrated above. Now your task will be to break down the calculations sum(aggr(sum())) and keep the case simple, rather than trying to fix an already very complicated expression.

It looks very interesting though what you're building

[#7]

Hi Martin,

I am happy to know that you have gained interested in the application I am working in a commodity trading business company and these   bits are parts of a big application built for the same purpose.

I completely accept your words of moving it into the script as its getting complicated in the chart level infact In the previous case I did the same if you check in my script I have a field called 'value',but this was simple without any variables in it so I did manage to do the same..but the voption is a complicated expression which has many variables in it and which works in the macro as well.This was a challenge for me as I am unable to call this in the script actually.If this is done my reference line formula would be much simpler.But unfortunately I have to do the reference lines for the above as well.

So can you suggest me how to proceed as I am still not able to resolve the reference lines issue,I am just not able to crack the expression to get the required lines

[#8]

Hi Martin,

Please help how to resolve above issue.

This is becoming very tough for me and doesnt work ,the reference lines are not coming 

I kindly request your help please.

Actually I am trying the other way as well( because the refresh time of my chart in increased too much,) ie to call the macro in the script and then renaming this complicated expression as a field and then use this field in the exp.

If you open the application in the table present I have a column called as option-chk.

now this same expression I want to put in the main script so that I can rename as 'A' etc and use it in various other columns.

eg the column net also used this exp and the next one too.

now in the script :

if you go to the payoff tab ,almost at the end I have tried to call this macro function 'Black 76' and then have given this exp as 'A'. But the macro function does not give erroe but when I load I get the error as invalid expression.So need ur precious help to resolve this.............please??

[#9]

I have ended up resolving the issue.

thanks for your help.