User Import filter products for specific countries

[ericdelaqua]

Hi All,

I have researched this in the community and tried a few suggestion but none is working for my requirement. Any ideas?

wihtout using the script and returning a flag, I would like to use the user import file to define a filter for Product A and B where the countrie is not BELGIUM or FRANCE.

is this possible? I have tried : [ProductCat]={Home,Garden,Kitchen},[Country]<>{FRANCE,BELGIUM}

Also tried

[ProductCat]={Home,Garden,Kitchen},[Country]-={FRANCE,BELGIUM}

Any ideas how to make this work. the list of countried applicable is huge and am trying to avoid listing all of them if possible

[Lech_Miszkiewicz · Accepted solution]

Hi @ericdelaqua, It is not 100% clear how you want to apply your filters from your description. 

I suggest you study my blog posts regarding filters: https://nprintingadventures.com/category/nprinting/filters/ especially:

• https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/
• https://nprintingadventures.com/2021/09/23/filters-in-nprinting-how-hard-can-it-be-part-2-or-mode/

Also - you need ask yourself a question if you are able to achieve such filter directly in Qlik applying "Advanced search" on the field.

If your filter is based on Product field you can use:

Field: Product, Advanced Search filter: =Count(Distinct {<[ProductCat]={'Home','Garden','Kitchen'},[Country]-={'FRANCE','BELGIUM'}>}Product) > 0

[ericdelaqua]

thanks @Lech_Miszkiewicz . I used your advance search suggestion