topic Max value doesn't work ? in QlikView

Max value doesn't work ?

Wed, 03 Jun 2009 15:52:31 GMT

Hello,

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

In this case:

Load * Inline[

dat , qty

01/01/2009 ,10

02/01/2009 , 50

05/01/2009 , 100 ] ;

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

Max value doesn't work ?

Wed, 03 Jun 2009 16:18:59 GMT

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.

Max value doesn't work ?

Wed, 03 Jun 2009 16:20:24 GMT

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

Max value doesn't work ?

Wed, 03 Jun 2009 16:49:29 GMT

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

Max value doesn't work ?

Wed, 03 Jun 2009 17:02:20 GMT

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.

Max value doesn't work ?

Wed, 03 Jun 2009 17:03:53 GMT

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.

Max value doesn't work ?

Thu, 04 Jun 2009 16:45:10 GMT

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

Max value doesn't work ?

Thu, 04 Jun 2009 17:35:24 GMT

Hi,

Check this attached application.

Hope this would help you.

- Sridhar

Max value doesn't work ?

Tue, 09 Jun 2009 17:16:50 GMT

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

Max value doesn't work ?

Tue, 09 Jun 2009 17:26:06 GMT

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

Max value doesn't work ?

Tue, 09 Jun 2009 19:37:26 GMT

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

Max value doesn't work ?

Tue, 09 Jun 2009 19:47:10 GMT

Hi,

Check this attachment.

- Sridhar

Max value doesn't work ?

Wed, 10 Jun 2009 03:49:26 GMT

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

Max value doesn't work ?

Thu, 11 Jun 2009 02:00:28 GMT

Hi at All,

I solved !

Many thanks|

Best Regards.

Slash