Set Analysis (using Inferior) & Animate

[#1]

Hi there,

I have a graph showing the price of the Brent index: forward and spot.

I would like to create a set analysis that allow me when the CurveDate is selected to draw the complete spot historic curve until that select date. In fact something like :

sum({1<Date={"< CurveDate"}}SpotPrice)

But i know that this syntax is not right.

Any help please?

another point is that i wonder if it was possible to animate this graph to see the curve drawing step by step since the older date.

Thx for your help.

Enclosed the exemple.

[#2]

Hi,

Isn't the problem with your set analysis code that you're missing the closing '>' for the modifier part of the expression?

Instead of sum({1<Date={"< CurveDate"}}SpotPrice) it should read sum({1<Date={"< CurveDate"}>}SpotPrice)

Regards,

Martijn ter Schegget

[johnw]

I think the problem is that you can't just reference a field value directly like this in set analysis. I believe it will look for values of Date less than or equal to the text literal, 'CurveDate', which probably will do nothing since dates are numbers. To get to the actual value of the field, I believe you need to use a dollar sign expansion. Something like this:

sum({1<Date={"<= $(=max(CurveDate))"}>} SpotPrice)