Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
G3S
Creator III
Creator III

Ignore one selection in aggr function

hi,

my master measure calculation is: sum(aggr(ShippedTEU,CntrSeal))

There are multiple filters that get applied(YearWeek_Filter, Carrier_Filter, Region_Filter etc). The requirement is to ignore the selection from the 'Carrier_Filter' so overall shipped teu number is shown even when a carrier is selected (to view carrier specific performance and overall performance side by side).

I've tried the following two but it does not work: 

  • sum({<Carrier_Filter=>}aggr(ShippedTEU,CntrSeal))
  • sum( aggr( {<Carrier_Filter-={"(=GetfieldSelections(Carrier_Filter))"}>}ShippedTEU,CntrSeal))
    +
    sum(aggr(ShippedTEU,CntrSeal))

appreciate any help please.

Labels (4)
1 Solution

Accepted Solutions
G3S
Creator III
Creator III
Author

For anyone with similar requirement...

I used 'alternate state'. the filter containing 'carrier_filter' dimension got  new alternate state applied. whatever dimension is  required to be excluded (in my case, selection from 'carrier_filter to be ignored) needs to have the alternate state applied.

View solution in original post

1 Reply
G3S
Creator III
Creator III
Author

For anyone with similar requirement...

I used 'alternate state'. the filter containing 'carrier_filter' dimension got  new alternate state applied. whatever dimension is  required to be excluded (in my case, selection from 'carrier_filter to be ignored) needs to have the alternate state applied.