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:








      Questions and answers

      <question date>


      <answer date>



      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.