Load Script: Max(Date) Group by

[reporting_neu]

Hello,

I have a problem with the max (date) and grouping.

I only need the data with the highest date of occurrence "Part, Storagearea, Storagelocation, Storageplace".

Qlik wants me to include the quantity in the grouping. But then I have the same result as before.

NoConcatenate
TMP2:
Load

  Part
, Storagearea
, Storagelocation
, Storageplace
, max(date(InventurDate)) as InventurDate
, Quantity

From [$(SCRIPT_PATH_PA_TRANSFORM)table.qvd](qvd)
Group by
  Part
, Storagearea
, Storagelocation
, Storageplace
;

If I add the "InventurDate", it doesn't work either.

Can you help me please?

[reporting_neu · Accepted solution]

I have the solution. I have to add up the quantiy.

Like:

Sum(Quantity) as Quantity