topic Filter pane - multiple data in a field - Qlik Sense in App Development https://community.qlik.com/t5/App-Development/Filter-pane-multiple-data-in-a-field-Qlik-Sense/m-p/1306886#M27839 <HTML><HEAD></HEAD><BODY><P>Hello experts!</P><P>I have a field "country" in which countries related to some products are listed in this way:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Product</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Country</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>...</STRONG></TH></TR><TR><TD style="padding: 2px;">xxx</TD><TD style="padding: 2px;">Italy</TD><TD style="padding: 2px;">...</TD></TR><TR><TD style="padding: 2px;">zzz</TD><TD style="padding: 2px;">Italy | France | Germany</TD><TD style="padding: 2px;">...</TD></TR><TR><TD style="padding: 2px;">www</TD><TD style="padding: 2px;">Germany| USA | Denmark | Spain | China</TD><TD style="padding: 2px;">...</TD></TR></TBODY></TABLE><P></P><P>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.</P><P></P><P>Any help?</P><P></P><P>Thank you!</P></BODY></HTML> Tue, 09 May 2017 07:29:11 GMT 2017-05-09T07:29:11Z Filter pane - multiple data in a field - Qlik Sense https://community.qlik.com/t5/App-Development/Filter-pane-multiple-data-in-a-field-Qlik-Sense/m-p/1306886#M27839 <HTML><HEAD></HEAD><BODY><P>Hello experts!</P><P>I have a field "country" in which countries related to some products are listed in this way:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Product</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Country</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>...</STRONG></TH></TR><TR><TD style="padding: 2px;">xxx</TD><TD style="padding: 2px;">Italy</TD><TD style="padding: 2px;">...</TD></TR><TR><TD style="padding: 2px;">zzz</TD><TD style="padding: 2px;">Italy | France | Germany</TD><TD style="padding: 2px;">...</TD></TR><TR><TD style="padding: 2px;">www</TD><TD style="padding: 2px;">Germany| USA | Denmark | Spain | China</TD><TD style="padding: 2px;">...</TD></TR></TBODY></TABLE><P></P><P>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.</P><P></P><P>Any help?</P><P></P><P>Thank you!</P></BODY></HTML> Tue, 09 May 2017 07:29:11 GMT https://community.qlik.com/t5/App-Development/Filter-pane-multiple-data-in-a-field-Qlik-Sense/m-p/1306886#M27839 2017-05-09T07:29:11Z Re: Filter pane - multiple data in a field - Qlik Sense https://community.qlik.com/t5/App-Development/Filter-pane-multiple-data-in-a-field-Qlik-Sense/m-p/1306887#M27840 <HTML><HEAD></HEAD><BODY><P>Try this script</P><P></P><P><STRONG>Table:</STRONG></P><P><STRONG>LOAD * INLINE [</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; Product, Country</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; xxx, Italy</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; zzz, Italy | France | Germany</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; www, Germany| USA | Denmark | Spain | China</STRONG></P><P><STRONG>];</STRONG></P><P></P><P><STRONG>LinkTable:</STRONG></P><P><STRONG>LOAD Country,</STRONG></P><P><STRONG>&nbsp; Trim(SubField(Country, '|')) as CountryFilter</STRONG></P><P><STRONG>Resident Table;</STRONG></P><P></P><P>Use CountryFilter field for filtering</P></BODY></HTML> Tue, 09 May 2017 12:07:13 GMT https://community.qlik.com/t5/App-Development/Filter-pane-multiple-data-in-a-field-Qlik-Sense/m-p/1306887#M27840 sunny_talwar 2017-05-09T12:07:13Z