<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic AW:Multiple values in one field (display in a listbox) in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Multiple-values-in-one-field-display-in-a-listbox/m-p/182066#M47864</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hallo Juppinger,&lt;/P&gt;&lt;P&gt;I'd do it as in enclosed example.&lt;/P&gt;&lt;P&gt;Rgds,&lt;BR /&gt;Joachim&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 09 Jun 2010 14:23:13 GMT</pubDate>
    <dc:creator>biester</dc:creator>
    <dc:date>2010-06-09T14:23:13Z</dc:date>
    <item>
      <title>Multiple values in one field (display in a listbox)</title>
      <link>https://community.qlik.com/t5/QlikView/Multiple-values-in-one-field-display-in-a-listbox/m-p/182065#M47863</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;CODE&gt;&lt;/CODE&gt;&lt;/P&gt;&lt;P&gt;&lt;CODE&gt;Hi everybody,&lt;/CODE&gt;&lt;/P&gt;&lt;P&gt;&lt;CODE&gt;take a look at some example data:&lt;/CODE&gt;&lt;/P&gt;&lt;P&gt;&lt;CODE&gt;id | company | categories&lt;BR /&gt;-------------------------------------------------------------&lt;BR /&gt;1000 | Apple | computer;mobile;advertising&lt;BR /&gt;1001 | Microsoft | computer;software&lt;BR /&gt;1002 | Dell | computer&lt;/CODE&gt;&lt;/P&gt;&lt;P&gt;&lt;CODE&gt;As you can see, the field "categories" can have multiple items separeted by a semicolon.&lt;BR /&gt; Now I want to display the values in a listbox. But NOT this way:&lt;/CODE&gt;&lt;/P&gt;&lt;P&gt;&lt;CODE&gt;Listbox:&lt;BR /&gt;------------&lt;BR /&gt;computer;mobile;advertising (1)&lt;BR /&gt;computer;software (1)&lt;BR /&gt;computer (1)&lt;/CODE&gt;&lt;/P&gt;&lt;P&gt;&lt;CODE&gt;I want to show the values this way:&lt;/CODE&gt;&lt;/P&gt;&lt;P&gt;&lt;CODE&gt;Listbox:&lt;BR /&gt;------------&lt;BR /&gt;computer (3)&lt;BR /&gt;mobile (1)&lt;BR /&gt;advertising (1)&lt;BR /&gt;software (1)&lt;/CODE&gt;&lt;/P&gt;&lt;P&gt;&lt;CODE&gt;Could you help me please?&lt;/CODE&gt;&lt;/P&gt;&lt;P&gt;&lt;CODE&gt;Thank,&lt;BR /&gt;jup&lt;/CODE&gt;&lt;/P&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 09 Jun 2010 13:02:17 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Multiple-values-in-one-field-display-in-a-listbox/m-p/182065#M47863</guid>
      <dc:creator />
      <dc:date>2010-06-09T13:02:17Z</dc:date>
    </item>
    <item>
      <title>AW:Multiple values in one field (display in a listbox)</title>
      <link>https://community.qlik.com/t5/QlikView/Multiple-values-in-one-field-display-in-a-listbox/m-p/182066#M47864</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hallo Juppinger,&lt;/P&gt;&lt;P&gt;I'd do it as in enclosed example.&lt;/P&gt;&lt;P&gt;Rgds,&lt;BR /&gt;Joachim&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 09 Jun 2010 14:23:13 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Multiple-values-in-one-field-display-in-a-listbox/m-p/182066#M47864</guid>
      <dc:creator>biester</dc:creator>
      <dc:date>2010-06-09T14:23:13Z</dc:date>
    </item>
  </channel>
</rss>

