fgh

Thu, 12 Dec 2013 11:16:21 GMT

Hello,

I have a small problem which I cant solve. I have had some very helpful answers on here but was trying to solve the problem in table graph formulas which I now dont think I can do. So the alternative is to import the data and deal with it on import. here is my problem

Original data
ref1	date	Amount
123456	01/05/2013	100
123456	02/05/2013	200
123456	03/05/2013	200
123456	04/05/2013	100
123456	05/05/2013	200
123456	06/05/2013	100
123456	07/05/2013	200
123456	08/05/2013	100
123456	09/05/2013	150
ABCDE	01/05/2013	100
ABCDE	02/05/2013	100
ABCDE	03/05/2013	100
ABCDE	04/05/2013	100
ABCDE	05/05/2013	100
ABCDE	06/05/2013	150
ABCDE	07/05/2013	100
ABCDE	08/05/2013	100
ABCDE	09/05/2013	100
What I want it to look like in QV
ref1	date	Amount	Amount2
123456	01/05/2013	100	100
123456	02/05/2013	200	200
123456	03/05/2013	200	200
123456	04/05/2013	100	100
123456	05/05/2013	200	200
123456	06/05/2013	100	100
123456	07/05/2013	200	200
123456	08/05/2013	100	100
123456	09/05/2013	150
ABCDE	01/05/2013	100	100
ABCDE	02/05/2013	100	100
ABCDE	03/05/2013	100	100
ABCDE	04/05/2013	100	100
ABCDE	05/05/2013	100	100
ABCDE	06/05/2013	150	150
ABCDE	07/05/2013	100	100
ABCDE	08/05/2013	100	100
ABCDE	09/05/2013	100

You will see that for each ref I want to remove the value corresponding to the max date for that reference.

Does anyone know how I would achieve this.

Thanks in advance

Re: fgh

Nicole-Smith — Thu, 12 Dec 2013 15:06:39 GMT

See the load script in the attached:

Re: fgh

Thu, 12 Dec 2013 17:58:36 GMT

Thank a lot very helpful has solved my problems. Cheers

Alan

topic fgh in QlikView

fgh

Re: fgh

Re: fgh