topic Re: Aggr and only? in QlikView

Aggr and only?

Mon, 26 Jan 2026 18:19:17 GMT

I started with a table like this.

The result I wanted was to get the highest date (Dim 5) over Dim 1 and 2.

With an aggregation like this:

=Date(Aggr(DISTINCT max(Dim 5),Dim 1, Dim 2),'YYYY-MM-DD')

..I got something good to start with:

Now to my question - how do I filter Dim 6 so I only get the one that 'connects' to the highest date?

As a result as below?

sunny_talwar — Tue, 08 Dec 2015 17:31:34 GMT

May be replace Dim6 with this:

=Aggr(FirstSortedValue(Dim6, -Dim5), Dim1, Dim2, Dim5)

=Aggr(FirstSortedValue([Dim 6], -[Dim 5]), [Dim 1], [Dim 2])

sunny_talwar — Tue, 08 Dec 2015 17:41:19 GMT

Or just use this as your expression and leave Dim 5 and Dim 6 as is:

=Aggr(FirstSortedValue(Aggr(Sum(something), [Dim 1], [Dim 2], [Dim 5], [Dim 6]), -[Dim 5]), [Dim 1], [Dim 2])

Wed, 09 Dec 2015 07:48:32 GMT

Thank you, that did the trick.

Wed, 09 Dec 2015 07:58:51 GMT

Thank you, but in your example you get the lowest date.

sunny_talwar — Wed, 09 Dec 2015 18:25:09 GMT

Awesome