topic AGGR() in QlikView

AGGR()

Wed, 25 Nov 2020 16:16:04 GMT

I want to create a new table with a new field in the load script, this field ahould be calculated as following

AGGR(MAX(DATE),AGENT)

But, as I understand, this function is only for set analysis. Is there an opportunity to make such field using other functions?

sunny_talwar — Wed, 26 Oct 2016 17:22:53 GMT

You can do something like this:

Fact:

LOAD Date,

Agent,

OtherFields...

FROM Source;

AggregatedTable:

LOAD Agent,

Max(Date) as MaxDate

Resident Fact

Group By Agent;