topic Re: Return value based on min from different column in QlikView

Return value based on min from different column

Tue, 29 Nov 2016 14:36:56 GMT

Hi all,

let's say I have a table:

I need to select data per Item from Quantity column where Delivery is lowest.

Target is to get following in chart table:

Item	Quantity	Delivery
12345	10	1.12.2016
23456	5	3.12.2016

Is it possible via set analyses or something, or do I have to prepare the data in script, using for example mapping?

Select lowest Delivery is simple, but how do I return data from different column once I found lowest date?

Following shows script error:

only({<[Delivery]={min([Delivery])}>},Quantity)

marcus_sommer — Tue, 29 Nov 2016 14:44:57 GMT

Try it with: firstsortedvalue(Quantity, -Delivery) where Delivery must be a real date respectively numeric.

- Marcus

sunny_talwar — Tue, 29 Nov 2016 14:47:40 GMT

Just a slight modification. If you want this based on minimum value of delivery, I would not use -Delivery

FirstSortedValue(Quantity, Delivery)

MK_QSL — Tue, 29 Nov 2016 15:02:27 GMT

For 23456 MinDate mentioned is 3.12.2015 Which is not in Source Data.. !!

sunny_talwar — Tue, 29 Nov 2016 15:04:03 GMT

Hahahahaha good one

Tue, 29 Nov 2016 15:23:13 GMT

Thank you, I updated it

Tue, 29 Nov 2016 15:23:43 GMT

Thank you for the hint