0 Replies Latest reply: Mar 22, 2012 10:13 AM by matthijsz RSS

    Filter on source

      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.