But if I remove Country from total and keep set analysis, ProductName filter is working
Yes sorry typed Product Name by mistake
I require Set Analysis because there is no direct mapping between TEU and ProductName, both come from different sources which are later concatenated into one table. So if I don't use Set Analysis, ProductName filter will work but TEU will go 0, whereas we want total TEU.
If i understand you the problems appears to be more down to the data model.
Using the set expression {<Field>} tells Qlik to ignore selections on the field for that set analysis. If the interaction between TEU and Product Name aren't what you need i would look at the script / Data model.
