Latest value when choosing date

[Anonymous]

Hi,

Is there a way to show the last change of a value depending on what date you choose?

For example, i have an interest of 3,4% on June 6th, the next change to that interest was at July 10th. When I, in my application choose to look at June 30th

I want to see the interest 3,4% right now i don't see anything.

I have connected the change date of the interest with the calendar dates. And the calendar dates are generated.

Thanks in advance!

//A.

[Anonymous]

thanks!

it looks better but i'm still having problems and i think it has to do with my source data. you see, i have one table that contains:

bank,

rate,

date (date where the interest changed)

and then i have another table that contains

ratename (the type of rate (3 month, 1 year etc. one bank can have several ratenames hence several rates with different dates)

i've attaced my file with my data and hoping you can help me.

Thanks in advance!

[gandalfgray]

Hi Annika

I have opened the attached qvw

What is the problem you are having?

/gg

[Anonymous]

Ok. a few examples of "wrongs":

if you look at "Freedom Finance" in the field "name" they only have one date when it comes to "DateEffectiveFrom" that's ok, but. If you look at "Date" they don't have any. You should be able to choose all dates up until today. since there has not been a change to any of the timenames yet.

Enother example is if you choose name="Handelsbanken" and timename="1 år" you can see that the latest Date you can choose is 2011-07-03 but i should be today.

[gandalfgray]

Hi Annika

I can't really say, what's wrong with your app, because I don't have your sourcedata.

But if you try my attached app where the sourcedata is like this:

sourceInterest:

LOAD * INLINE [

    Rate, DateEffective, MoreFields, EvenMoreFields

    3.5, 2011-06-15, SBAB, 998

    3.9, 2011-04-01, Handelsbanken, 3mån

    4.0, 2011-05-01, Handelsbanken, 1år

    4.4, 2011-07-07, Handelsbanken, 1år

    4.2, 2011-07-07, Handelsbanken, 3mån

    3.1, 2011-01-01, Nordea, 6445

];

you can see that if you choose Handelsbanken + 1år + Rate 4.4 all the dates from 2011-07-07 up to 2011-08-23 is possible.

(btw: I can't reproduce your "Freedom Finance" problem in your app. iIf I choose Freedom Finance I have dates from 2011-07-06 and upto 2011-08-21 (which is as far as you have generated the calendar))