<?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 Filter on source in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Filter-on-source/m-p/364920#M1179354</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi all,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;First time post &lt;IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have three datasources:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Messages&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;lt;date&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;lt;title&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;lt;message&amp;gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Questions and answers&lt;/P&gt;&lt;P&gt;&amp;lt;question date&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;lt;question&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;lt;answer date&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;lt;answer&amp;gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;In Qlikview, I would like to show three tables, one with messages, one with questions and one with answers.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;What I did, was normalize all date fields on load and importing the questions-and-answers table twice (once to create a 'questions' table in Qlikview and once to create an 'answers' table in qlikview). I renamed &amp;lt;question date&amp;gt; and &amp;lt;answer date&amp;gt; to &amp;lt;date&amp;gt;, so everything is now linked on &amp;lt;date&amp;gt;.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I can make a table that shows things from the three sources, but how do I create three separate tables?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Next step is to create a time selection field, so you can say give me all messages, questions and answers in january.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 22 Mar 2012 14:13:20 GMT</pubDate>
    <dc:creator />
    <dc:date>2012-03-22T14:13:20Z</dc:date>
    <item>
      <title>Filter on source</title>
      <link>https://community.qlik.com/t5/QlikView/Filter-on-source/m-p/364920#M1179354</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi all,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;First time post &lt;IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have three datasources:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Messages&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;lt;date&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;lt;title&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;lt;message&amp;gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Questions and answers&lt;/P&gt;&lt;P&gt;&amp;lt;question date&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;lt;question&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;lt;answer date&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;lt;answer&amp;gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;In Qlikview, I would like to show three tables, one with messages, one with questions and one with answers.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;What I did, was normalize all date fields on load and importing the questions-and-answers table twice (once to create a 'questions' table in Qlikview and once to create an 'answers' table in qlikview). I renamed &amp;lt;question date&amp;gt; and &amp;lt;answer date&amp;gt; to &amp;lt;date&amp;gt;, so everything is now linked on &amp;lt;date&amp;gt;.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I can make a table that shows things from the three sources, but how do I create three separate tables?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Next step is to create a time selection field, so you can say give me all messages, questions and answers in january.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 22 Mar 2012 14:13:20 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Filter-on-source/m-p/364920#M1179354</guid>
      <dc:creator />
      <dc:date>2012-03-22T14:13:20Z</dc:date>
    </item>
  </channel>
</rss>

