seek value from the last date

Fri, 05 Nov 2010 18:05:29 GMT

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?

seek value from the last date

Tue, 09 Nov 2010 17:04:21 GMT

can someone help me?

topic seek value from the last date in QlikView

seek value from the last date

seek value from the last date