Max value doesn't work ?

[#1]

Hello,

I need a support. I would to found the max data in a field.

In this case:

a:

Load * Inline[

dat , qty

01/01/2009 ,10

02/01/2009 , 50

05/01/2009 , 100 ] ;

b:

Load

Max(dat as Maxdate,

qty resident a: Group by dat, qty;

I aspect

05/01/2009 in the Maxdate, field. But doesn't work.

Please could to help me someone?

Thanks

Best Regards

Sl

[#2]

If I select in the week object the item 7, in the sales resolved 2 Items:

in the sales Object I found

4 referred to 10/02/2009

5 referred to 14/02/2009

I would to shows JUS Sales =5 becouse I filtered by max date amd the max date is linked to sales=5

Thank yo

Best regardsu

Slash

[#3]

Hi,

Check this attachment.

- Sridhar

[#4]

Dear QV friend,,

yes is what I was looking doe.

I thank you for your help but I do not able to apply the example in my application.

I need to store a table bexouse the fields will be rewrite and do not store. To atore the data in the table I need to store and load the qvs file.

I need to apply your example in my application:

---------------------------------------------------------------------------------------------------------------------------------

mytable:

// I load the table I stored becouse the data are always rewrite and I nedd to store it
in qvd file. The store will be by timestamp..

Load *
from ..\mypath\db.qvd;

load
costAmount,
timestamp(ReloadTime()) as Date,
"Quantity",
item,
remainingQTY,
description
From ...

store * from mytable: into ..\mypath\db.qvd;
Load *
from ..\mypath\db.qvd

------------------------------------------------------------------------------------------------------------------------------------------------------------

I need to aggregate the field lik your example. by max date ( data format timestamp) and the linked values of :

costAmount,
"Quantity",
remainingQTY,

and dimensions:

timestamp(ReloadTime()) as Date,
item,
description

Please is many time I need to solved it.. Could to help me?

Thanks

--Slash

[#5]

Hi at All,

I solved !

Many thanks|

Best Regards.

--

Slash