Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Ignoring filter on dimension in aggr function

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

Labels (1)
1 Solution

Accepted Solutions

Re: Ignoring filter on dimension in aggr function

Try this

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

3 Replies
Not applicable

Re: Ignoring filter on dimension in aggr function

Hi,

use the below.

sum({<dimo1= >}facts)

Re: Ignoring filter on dimension in aggr function

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

or

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

Re: Ignoring filter on dimension in aggr function

Try this

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

Community Browser