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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
G3S
Creator III
Creator III

Ignoring user selection in one field

Hi,

in the app, I have multiple fields as filters. 

fields 'Version' and  'Carrier' will be selected. I need to keep field 'Version' (and selections from other fields) & ignore selection in 'Carrier' completely to calculate TotalTEU. Please help to calculate TotalTEU.

POLCarrierVersionCntrTEUTotalTEU
NaplesAAA2020200300
NaplesBBB2020100300

 

calculating Cntr TEU with this expression: 

sum(aggr(([CntrTEU]),[CntrSeal]))

 

thank you

Labels (2)
10 Replies
G3S
Creator III
Creator III
Author

@Taoufiq_Zarra 

thank you for your time. These are the outputs I get. 

qlik_POL_Total to forum.jpg

 

 

 

 

 

the output I require is  table 1 but even when selection is made  in 'carrier'.

shippedTEU column  is calculated with this expression:    sum(aggr(([CntrTEU]),[CntrSeal]))