Qlik Max function with Aggr

[Vikas]

Hi All,

Can you help what is wrong in this set expression , this is showing NULL value.

Aggr(Max({<[Type Category]={'NEW','OLD'}, Group={'NORTH'}>} [Create Date]), [Name])

I wants to calculate Max Create Date for [Type Category] =  NEW and OLD and Group = NORTH aggregated by Name.

Thanks,

Vikas

[BrunPierre]

Is [Create Date] properly formatted as Date?

[tresesco]

It's important to know the context; where are you using this expression, in a kpi object or in a chart? If in a chart, what are the dimensions?