topic Re: aggr in QlikView

aggr

satishqlik — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a table contains id, department, date, amount

In pivot table, My dim is department and expression sum(amount)

and added count(id) as my second dimension

am trying to show in my calculated dimension,Count(id) of Max(Month) for each department.

how do we achieve this??

PFB for your reference!!

Please suggest.!!

sunny_talwar — Fri, 07 Jul 2017 12:34:03 GMT

May be this

=Aggr(If(Month = Max(TOTAL <dept> Month), Count(id)), dept, Month)

sunny_talwar — Fri, 07 Jul 2017 12:35:16 GMT

For the sample you attached

satishqlik — Fri, 07 Jul 2017 12:39:53 GMT

Thanks Sunny !!!!