chart expression filter for all field values

[andriesb]

I would like to filter my ' Pivot table'  chart's  expression output to show  the total sum only for the customer listed within a certain other field (all possible values). The amount of the filtered customers could change (after a rebuild), so a fixed list of values for filtering as show in other examples within the community is not an option.

I could solve this at first when adding the field ListOfCustomersToBeFiltered as a dimension and use ' Surpress all values Is Null'. 

Disadvantage is that the customers number would also show and I just want to show the totals of these filtered customers list: 

I thought it could be solved with an expression that should be like :

= Sum({<  MyCustomers = {ListOfCustomersToBeFiltered}    >} Weights)

but that does not work. Any suggestions if this is possible in this 'easy'  way ?

[agni_gold · Accepted solution]

This might help :

https://community.qlik.com/t5/QlikView-App-Development/P-E-and-where-do-you-use-them/td-p/457847

[andriesb]

I never came across these functions before , but it did the trick ! Thanks !