Filter on source

[#1]

Hi all,

First time post

I have three datasources:

Messages

<date>

<title>

<message>

Questions and answers

<question date>

<question>

<answer date>

<answer>

In Qlikview, I would like to show three tables, one with messages, one with questions and one with answers.

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 <question date> and <answer date> to <date>, so everything is now linked on <date>.

I can make a table that shows things from the three sources, but how do I create three separate tables?

Next step is to create a time selection field, so you can say give me all messages, questions and answers in january.