Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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

Re: Filter pane - multiple data in a field - Qlik Sense

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

1 Reply

Re: Filter pane - multiple data in a field - Qlik Sense

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