topic Re: AGGR Function in QlikView

AGGR Function

kishorj1982 — Tue, 24 Oct 2017 11:36:56 GMT

Hi All,

I need to show unit cost for max(DtDate) for combination of branch plant and part number.

I used below formulae but no luck.

sum({<DtDate={'$(=max(aggr(max(DtDate),BranchPlant,PartNumber)))'}>} UnitCost)

Thanks

sunny_talwar — Tue, 24 Oct 2017 11:50:12 GMT

May be create a new field in the script like this

AutoNumber(BranchPlant&PartNumber) as NewField

and then try this

Sum({<NewField = {"=DtDate = Max(TOTAL <NewField> Aggr(DtDate, NewField, DtDate))"}>}UnitCost)

tresB — Tue, 24 Oct 2017 11:59:23 GMT

May be using a straight table:

Dim1: BranchPlant

Dim2: PartNumber

Exp: FirstSortedValue( Aggr(Sum(UnitCost),DtDate), -DtDate)