topic Re: Want to find Max. in QlikView

Want to find Max.

Sxbbb — Fri, 25 Nov 2022 08:22:01 GMT

Want to find Max of Type = CU IN HOLE DIF

Re: Want to find Max.

BrunPierre — Fri, 25 Nov 2022 09:32:36 GMT

Maybe this

Aggr(Only({<CU_BoardNo={"$(=Max(CU_BoardNo))"},CU_TypeHole={'CU IN HOLE DIF'}>}CU_TypeHole),FA_ID)

Re: Want to find Max.

Sxbbb — Fri, 25 Nov 2022 09:44:10 GMT

This is result

but I want Result Type = CU IN HOLE DIF

Re: Want to find Max.

BrunPierre — Fri, 25 Nov 2022 10:31:02 GMT

Give it another go.

Sum(Aggr(Sum({<CU_BoardNo={"$(=Max(CU_BoardNo))"},CU_TypeHole={'CU IN HOLE DIF'}>}CU_HoleMax),FA_ID))

Re: Want to find Max.

Sxbbb — Mon, 28 Nov 2022 01:43:00 GMT

This is result . but I want Result Type CU IN HOLE DIF =40.29

Re: Want to find Max.

MayilVahanan — Mon, 28 Nov 2022 06:00:21 GMT

Try like below

Max(Aggr(Sum({<CU_BoardNo={"$(=Max(CU_BoardNo))"},CU_TypeHole={'CU IN HOLE DIF'}>}CU_HoleMax)

,FA_ID,CU_BoardNo))

Re: Want to find Max.

Sxbbb — Mon, 28 Nov 2022 06:09:40 GMT

This is result.

Re: Want to find Max.

Sxbbb — Mon, 28 Nov 2022 06:10:28 GMT

not as desired

Re: Want to find Max.

Sxbbb — Mon, 28 Nov 2022 06:23:04 GMT

Want max value

with different ID

Re: Want to find Max.

BrunPierre — Mon, 28 Nov 2022 07:31:56 GMT

Maybe add RecNo() to your load script like this.

LOAD CU_TypeHole
.......,
RecNo() as R#

FROM SourceTable;

And here's an expression you can try

Sum(Aggr(Sum({<CU_BoardNo={"$(=Max(CU_BoardNo))"},CU_TypeHole={'CU IN HOLE DIF'},R#={"$(=Max(R#))"}>}CU_HoleMax),CU_BoardNo,FA_ID))

Re: Want to find Max.

Sxbbb — Mon, 28 Nov 2022 08:02:50 GMT

I don't understand, I just want  an expression

Re: Want to find Max.

BrunPierre — Mon, 28 Nov 2022 08:11:31 GMT

Can you share a sample data/app?

Re: Want to find Max.

Sxbbb — Mon, 28 Nov 2022 08:24:18 GMT

That is, I need to find the Max value of each Type, each Id. Now I'm looking for the max value of Type =CU IN HOLE DIF.

This is all information. There are two ID in this data set

I want result Type CU IN HOLE DIF = 42.61 and 40.29

because there are two ID .

If it's Type CU ON SURFACE DIF, get max = 61.30 and 52.70

Do you understand?

Re: Want to find Max.

BrunPierre — Mon, 28 Nov 2022 11:45:26 GMT

What about CU_BoardNo 1, 3, 4, 6 and 8, they equally have two IDs?

Re: Want to find Max.

Sxbbb — Mon, 28 Nov 2022 11:50:26 GMT

Yes, but I'm only interested in the ID of each data set, I don't care how many Board No.

Re: Want to find Max.

BrunPierre — Mon, 28 Nov 2022 18:54:20 GMT

Script

Temp: LOAD * Inline[ CU_TypeHole,CU_BoardNo,CU_HoleMax,CU_Symbol,FA_ID CU IN HOLE DIF,1,36.67,0.00,281F CU IN HOLE DIF,1,40.33,0.00,1D22 CU IN HOLE DIF,2,40.29,0.00,281F CU IN HOLE DIF,2,40.44,0.00,1D22 CU IN HOLE DIF,5,37.38,0.00,281F CU IN HOLE DIF,5,42.61,0.00,1D22 CU IN HOLE DIF,8,36.25,0.00,281F CU IN HOLE DIF,8,40.26,0.00,1D22 CU ON SURFACE DIF,1,36.67,0.00,281F CU ON SURFACE DIF,1,40.33,0.00,1D22 CU ON SURFACE DIF,2,40.29,0.00,281F CU ON SURFACE DIF,2,40.44,0.00,1D22 CU ON SURFACE DIF,5,37.38,0.00,281F CU ON SURFACE DIF,5,42.61,0.00,1D22 CU ON SURFACE DIF,8,36.25,0.00,281F CU ON SURFACE DIF,8,40.26,0.00,1D22 ]; NoConcatenate LOAD CU_TypeHole, CU_BoardNo, CU_Symbol, LastValue(CU_HoleMax) as CU_HoleMax, LastValue(FA_ID) as FA_ID Resident Temp Where CU_TypeHole = 'CU ON SURFACE DIF' Group By CU_TypeHole, CU_BoardNo, CU_Symbol; DROP Table Temp; EXIT SCRIPT;

Output