topic Get 2 min values in QlikView

Get 2 min values

bharatkishore — Wed, 25 Nov 2020 16:16:04 GMT

HI All,

I have the following columns in script:

Equipment,

[Part Group],

Key_EMS,

Calendar,

Age_Final,

Quantity

Need to get the output like below:

Equipment	Part Group	Key_EMS	Calendar	Age_Final	Quantity
E1	P1	Key2	2013-01	3	0
E1	P1	Key4	2013-01	5	1
E2	P1	Key7	2013-01	22	1
E2	P1	Key8	2013-01	15	0
E3	P2	Key10	2013-02	5	1
E3	P2	Key11	2013-02	5	0

And need to do sum of quantity and group by should be on following columns i.e Equipment,Part Group,Calendar

Please let me know if you need anything more.

Attached excel for reference:

Thanks,

Bharat

Re: Get 2 min values

vamsee — Mon, 24 Sep 2018 13:50:51 GMT

If your Group by is on Equipment,Part Group & Calendar, then can you please explain why the Quantity value differed for the first 2 lines in your expected output.

E1	P1	Key2	2013-01	3	0
E1	P1	Key4	2013-01	5	1

Re: Get 2 min values

timpoismans — Mon, 24 Sep 2018 13:52:06 GMT

Please refrain from creating multiple threads about the same issue.

The following threads already exist:

Rank in script

Need to get 2 ages

Creating multiple threads won't get your issue solved faster.

Re: Get 2 min values

timpoismans — Mon, 24 Sep 2018 13:56:28 GMT

As explained in his other two threads, he wants the two lowest values of [Age_Final] per Equipment, [Part Group], Calendar.

So the Sum(Quantity) is actually grouped by Equipment, [Part Group], Calendar and [Age_Final]