Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filter pane - multiple data in a field - Qlik Sense

Hello experts!

I have a field "country" in which countries related to some products are listed in this way:

ProductCountry...
xxxItaly...
zzzItaly | France | Germany...
wwwGermany| USA | Denmark | Spain | China...

I would like to create a filter pane that filters data by country, but with countries listed like this i have some issues. I cannot split countries in multiple fields because the filter pane has to be unique.

Any help?

Thank you!

1 Solution

Accepted Solutions
sunny_talwar

Try this script

Table:

LOAD * INLINE [

    Product, Country

    xxx, Italy

    zzz, Italy | France | Germany

    www, Germany| USA | Denmark | Spain | China

];

LinkTable:

LOAD Country,

  Trim(SubField(Country, '|')) as CountryFilter

Resident Table;

Use CountryFilter field for filtering

View solution in original post

1 Reply
sunny_talwar

Try this script

Table:

LOAD * INLINE [

    Product, Country

    xxx, Italy

    zzz, Italy | France | Germany

    www, Germany| USA | Denmark | Spain | China

];

LinkTable:

LOAD Country,

  Trim(SubField(Country, '|')) as CountryFilter

Resident Table;

Use CountryFilter field for filtering