3 Replies Latest reply: Nov 12, 2015 8:32 AM by Andy Weir RSS

    Using Multiple Table views - Qlik sense

    Joanna Seldon

      Hiya

       

      I have two views, which I wish to use within the qlik sense environment...

       

      one is DailyOrders, which is a view which brings back....Daily orders of every customer...and OrderDate are 01/01/2014, 02/01/2014 and so on

       

      Other is MonthlyOrders which is a view which brings back....weekly orders of every customer ... and OrderDate are 01/01/2014, 01/02/2014 and so on

       

      these two tables have exactly the same fields names...

       

      my current app and its charts contained within just looks at the MonthlyOrders,

       

      I wish to now join the DailyOrders

       

      I understand making a fact table will be best... but how

       

      please advise