topic Set Analysis (using Inferior) & Animate in QlikView

Set Analysis (using Inferior) & Animate

Wed, 08 Jul 2009 17:10:16 GMT

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.

Set Analysis (using Inferior) & Animate

Thu, 06 Aug 2009 23:24:12 GMT

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

Set Analysis (using Inferior) & Animate

johnw — Sat, 08 Aug 2009 04:32:30 GMT

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)