topic Re: Max value in QlikView

Max value

Dwyane — Thu, 15 Jul 2021 13:55:49 GMT

Hello

I have a table that looks like this

The output i am looking for the the last record so max col2 but only grouped by col1 and col4 with the additional columns so my output would be this

Col1	Col2	Col3	Col4	Col5	Col6	Col7
AAA	4	300	01/01/2020	Context A	Context Z	Context AC

I think i know how to do it in sql with a subquery but not sure how to so in Qlik script. Any help would be appreciated

Kushal_Chawda — Thu, 15 Jul 2021 14:08:08 GMT

@Dwyane try below

Data:
LOAD Col1,
Col2,
Col3,
Col4,
Col5,
Col6,
Col7
FROM Table;

Left Join(Data)
LOAD Col1,
Col4,
max(Col2) as Col2,
1 as Flag
Resident Data
Group by Col1,
Col4;

Final:
NoConcatenate
LOAD *
Resident Data
where Flag=1;

DROP Table Data;

Dwyane — Thu, 15 Jul 2021 14:10:06 GMT

Thanks for now i would just like to build a table via script nothing on the front-end just yet

Kushal_Chawda — Thu, 15 Jul 2021 14:12:53 GMT

@Dwyane what we have provided is the script solution only

Dwyane — Thu, 15 Jul 2021 15:57:54 GMT

Yes sorry i was responding to the other script that was posted which has been deleted