topic Re: Qlik Max function with Aggr in App Development

Qlik Max function with Aggr

Vikas — Thu, 01 Jun 2023 02:50:15 GMT

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 — Thu, 01 Jun 2023 06:39:38 GMT

Is [Create Date] properly formatted as Date?

tresB — Thu, 01 Jun 2023 06:39:57 GMT

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?