LOAD with GROUP BY with MAX

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

Hey guys,

I have a problem with a load with group by:

LOAD

Year,

Month,

max(B)

RESIDENT SomeOtherTable

GROUP BY Year, Month;

I want to group by Year and Month, and I want my A to show only in a case where B=max(B).

How can I achieve this?

Re: LOAD with GROUP BY with MAX

Kushal_Chawda — Fri, 09 Oct 2020 09:38:35 GMT

SomeOtherTable: LOAD Year, Month, B FROM table; inner join(SomeOtherTable) LOAD Year, Month, max(B) as B RESIDENT SomeOtherTable GROUP BY Year,Month;