Find value corresponding to the date

[#1]

I have a simple table, with "product name", "value" and " date of entry"

each product has several "dates of entry," where each "date of entry" it has a different value, for example:

A___01/01/08___200

A___02/02/08___50

A___03/03/08___140

B___10/01/08___88

B___20/02/09___100

B___30/03/10___360

but I don't want repeat the products (name), I want to show only the most recent. For that, I'm using "maxtring" in my "date of entry"(expression), so that it appears only the most recent date, but he brings no value... example:

A___03/03/08___ -

B___30/03/10___ -

- = (null)

*in the "value", I am not making any kind of calculation, I'm just bringing the "value" field

I think this happens because there is no relationship between the "date of entry" and "value", so it brings the most recent date, because I used a formula, but do it not know what value should bring ...

Anybody knows an expression I can put in "value" for it brings the value corresponding to the date?

can someone help me?

[#2]

??

[#3]

any suggestion?

[hector]

hi

can you upload an excel or qlikview file with the example??

by the way, if the date is a number (this depends if qlikview recognize the date format), use max() instead of maxstring

rgds

[#5]

Using this inline:

temp_inline:
LOAD * INLINE [
product, entry, value
a, 01/01/2008, 200
a, 02/02/2008, 50
a, 03/03/2008, 140
b, 01/01/2008, 88
b, 02/20/2009, 100
b, 03/30/2010, 360
];

I used this expression to determine the value based on the max entry date for the product:

sum(if(entry=aggr(nodistinct Max(entry),product),value))

[#6]

worked. Thank cisco, was what I needed

thanks for help