Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
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))

View solution in original post

3 Replies
Not applicable

Re: Ignoring filter on dimension in aggr function

Hi,

use the below.

sum({<dimo1= >}facts)

MVP
MVP

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))

View solution in original post