topic Re: Ignoring filter on dimension in aggr function in QlikView

Ignoring filter on dimension in aggr function

Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

I have an expression that uses and aggr function on dimension dim01. I also have provided the filter for dim01 on the same sheet. Now I want to have below expression calculated for all values of dim01 even if user have selected some values in dim01 filter.

max(aggr(sum(facts), dim01))

Please advise.

regards,

Salman

Re: Ignoring filter on dimension in aggr function

Tue, 14 Oct 2014 08:55:42 GMT

Hi,

use the below.

sum({<dimo1= >}facts)

Re: Ignoring filter on dimension in aggr function

MK_QSL — Tue, 14 Oct 2014 09:03:12 GMT

max(aggr(sum({$<dim01 = >}facts), dim01))

max({$<dim01 = >}aggr(sum({$<dim01 = >}facts), dim01))

Re: Ignoring filter on dimension in aggr function

CELAMBARASAN — Tue, 14 Oct 2014 09:04:22 GMT

Try this

max({<dim01=>}aggr(sum({<dim01>}facts), dim01))