Hi all,
First time post ![](/legacyfs/online/emoticons/happy.png)
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.