Filter not working as expected

[Diere29]

I have this measure/logic placed into a filter table in Qlik sense. 

=If(STORE_NUMBER = '0',
If(Match(country, 'NL'), 'EU',
If(Match(country, 'GB'), 'UK',
Region_Country)),
Region_Country)

its supposed to pick up values that are zero in a store number column if they are NL say its the EU and if its GB say UK and to otherwise go along with whatever is already in the region country field. 

when I use this filter in the table it doesn't really do anything or interact with the data as I'd expect. it automatically just drops out all of the values that have a store number of 0

anyone know why 

[rwunderlich]

I think you need to wrap this in an Aggr to connect this expression to actual field(s). See https://qlikviewcookbook.com/2016/01/scoping-selections-with-aggr/

-Rob

[Chanty4u · Accepted solution]

Try to create master dimension and use that in your filter panel 

If(STORE_NUMBER = '0',

    If(country = 'NL', 'EU',

    If(country = 'GB', 'UK', Region_Country)),

    Region_Country

)