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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
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.