Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Max value doesn't work ?

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

13 Replies
Not applicable
Author

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.

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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.

Not applicable
Author

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.





Not applicable
Author

CoolHello,

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 Cool

Please, could to help me?

Thanks . Best Regards.

Slash

Not applicable
Author

Hi,

Check this attached application.

Hope this would help you.

- Sridhar

Not applicable
Author

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

Not applicable
Author

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