topic Find value corresponding to the date in QlikView

Find value corresponding to the date

Wed, 10 Nov 2010 17:58:58 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?

Find value corresponding to the date

Wed, 10 Nov 2010 19:17:10 GMT

Find value corresponding to the date

Fri, 12 Nov 2010 18:48:49 GMT

any suggestion?

Find value corresponding to the date

hector — Fri, 12 Nov 2010 19:23:31 GMT

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

Find value corresponding to the date

Sat, 13 Nov 2010 00:29:29 GMT

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))

Find value corresponding to the date

Tue, 16 Nov 2010 17:14:53 GMT

worked. Thank cisco, was what I needed

thanks for help