topic Re: Aggregation expressions required by group by Clause in Applymap function in QlikView

Aggregation expressions required by group by Clause in Applymap function

Vinni2000 — Wed, 24 May 2023 18:36:18 GMT

Order:

Load

Locationnumber,

Ordernumber,

Locationnumber &'-'&Ordernumber as po_number,

Itemnumber,

Voidind

From qvd;

VoidMap:

Mapping Load

po_number,

If(IsNull(Voidind),'not voided','voided') as voidstatus,

Resident Oder

Group by po_number;

Order1:

LOAD

ApplyMap('VoidMap',po_number,'Not voided') as orderstatus

Resident Order;

Drop table Order

rubenmarin — Wed, 24 May 2023 18:40:07 GMT

Hi, if there is a group by you need an aggreation expression for the fields not included in the group by clause, like:

Mapping Load

po_number,

If(IsNull(Max(Voidind)),'not voided','voided') as voidstatus,

Resident Oder

Group by po_number;

You can also use maxstring if Voidind is a text.