need min and max value in a line chart with extra condition.please help

[#1]

Hi all,

Please help me out to resolve the below issue.

If you open my application attached,I have a line chart and 2 text boxes.My line chart Xaxis is ranging from 75 to 95 presently because I have given the static min and max expressions in the properties to change it dynamically.(=round(avg(strike_price1)-10,1) )

The same way I want to do for my Y axis.

ie: for Xaxis value 75 I want min and max value of the expression present

payoff values=value*sum(Nominal_Quantity)

min and max of value*sum(Nominal_Quantity) at 75

min and max of value*sum(Nominal_Quantity) at 95

This is to make the chart more readable and not messy.

Please can you help me out please???????? is this possible???

[ThornOfCrowns]

No, you think you're showing only those values, but you're not. Qlikview is plotting all of the values of strike_price1, calculating the chart, then showing the maximum and minimum potential values as the upper and lower bounds.

You need to put a restrict in your expression such as:  

=

if(strike_price1>=75,
if(strike_price1<=95,
strike_price1))

which will then show the values you want as well as the upper and lower bounds in the chart.

[#3]

ya,but my strike_price1 is not fixed between 75 and 95 always.Only in this day's data its getting calculated as this number by the expression round(avg(strike_price1)-10,1) and round(avg(strike_price1)+10,1) given at the scale for X axis in static min and max .That is why I want my Y axis max and min value  to be dynamic as I cannot fix my strike_price1 to 75 /95 etc.

[ThornOfCrowns]

Put your two Rangemax(( round(avg(strike_price1)-10,1) )) expressions into two variables, then say

=

if(strike_price1>=$(vChartMin),

if(strike_price1<=$(vChartMax),

strike_price1))

[#5]

Hi James ,somehow its still not working .

You can have a look at the file attached.I have given your expression in a text box,as

=if(market>=$(minval),sum(Nominal_Quantity1)*value)

because when market>the variable the curve expressions min value  and max value should be displayed.It doesnt happen .

Now if you see my graph there are 2 lines so :

at market 75 :min=-180750, max=175500

    market 95 :min=-124500,max=94250

now this value is because in the list box callput_type PUT is selected,if you select CALL the same would change.

HEnce I want the range of my line charts max and min to correspond to the max and min of these values and not stretch till 700000 to -500000.

[ThornOfCrowns]

It doesn't work because your second QVW is different to the first.

It might have been better to post the second one and to have mentioned the two list boxes in your original requirement or your clarification June 16 2014, 08:09 AM.

Is there anything else to take into account whilst we're on?

[#7]

James I am actually working on these QVD's so are the changes.Sorry if it has confused my requirement to you.

This is it,no more things to be considered,we can stick to the latest qvd posted.Can you please help me resolve the same now?

[ThornOfCrowns · Accepted solution]

The attached file filters the graph based on selections in the two list boxes and between the range bounds. Hopefully the lines and numbers make some sense to you.

[#9]

Hi James,

its perfect!!!!!!! thanks a lot .I exactly wanted the same.

great logic.got to learn something gr8 thanks again

[ThornOfCrowns]

No probs, happy to help.