topic Re: Extract data record from max date in QlikView

Extract data record from max date

eptaqlik — Fri, 21 Apr 2017 11:48:35 GMT

Hello,

please someone can help me?

I want to extract from a file:

for any material code the last data, qty and price from a lot of movement.

material	data	qta	Price
a	17/01/2017	1	10
a	18/01/2017	2	11
a	19/01/2017	3	12
a	20/01/2017	4	13
a	21/01/2017	5	14
b	21/02/2017	5	20
b	22/02/2017	4	21
b	23/02/2017	3	22
b	24/02/2017	2	23
b	25/02/2017	1	24
c	17/03/2017	1	30
c	18/03/2017	2	31
c	19/03/2017	3	32
c	20/03/2017	4	33
c	21/03/2017	5	34
Result
a	21/01/2017	5	14
b	25/02/2017	1	24
c	21/03/2017	5	34

tks in advance.

Marco

Re: Extract data record from max date

tresB — Fri, 21 Apr 2017 13:05:46 GMT

Straight table:

Dim: Result

Exp1: Date(Max(data))

Exp2: FirstSortedValue(qta, -data)

Exp3: FirstSortedValue(Price, -data)

Re: Extract data record from max date

eptaqlik — Fri, 21 Apr 2017 13:41:41 GMT

many tks

It work very well.

have a nice day.

Marco

Re: Extract data record from max date

eptaqlik — Fri, 21 Apr 2017 13:42:10 GMT

many tks

It work very well.

have a nice day.

Marco