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]

Hello Si

It really depends on what you want to achieve with the result.

First, you can get the max date as a single field by changing your second load script to simply state LOAD Max(Dat) Resident A

The thing that you are doing is getting the max date grouped by date and qty, which basically means you will get each line from table a (because each combination of dat/qty is different.

Hope this helps.

Nigel.

[#3]

Sorry, just thought i'd attach an example......

[#4]

Thanks,

consider:

Target: I would to to obtain in oine field themax date and linked the qty referred to the max date.

Could you help me?

Thanks

Best regards,

Slash

[#5]

Hello Slash

I think I know what you need, so please take a look at the attached example, comments are in the load script.

Cheers,

Nigel.

[#6]

Hi Slash,

I think the problem is with the interpretation of the date.

If you use this piece of code it will work:

b:
load
date (Max(date#(dat,'dd/mm/yyyy'))) as Maxdate
resident a;

regards,

Walter.

[#7]

Hello,

Thanks. for your example. But I need to group the max date by week.

Example: I would to know in 2 week of the year (the xeek(dat) ) what was the maximum date . If I selekt a week number the field should be shows the maximum date referred of the week I select. Sorry for my bad english

Please, could to help me?

Thanks . Best Regards.

Slash

[#8]

Hi,

Check this attached application.

Hope this would help you.

- Sridhar

[#9]

Hello,

The file you attached is partial target thath I need.

I need to select a week number and the object should be show the max date of the linked week and the sales of the max date.

Could to help me?

Thank you very much.

Best Regards

--

Slash

[#10]

Hi,

I`m not sure what is your requirement ..? and what else is required from that application....?

Check the attached application.

if the attached application doesn`t solve your purpose , please post your sample data and explain your senario.

- Sridhar