4 Replies Latest reply: Jul 10, 2014 6:08 AM by Satyadev Jaiswal RSS

    Problem Seeing Full Data



      I have an excel table loaded with this data


      YearMonthCar         Expense

      201411                    100

      201421                    100

      201431                    100


      Sql table with this data


      YearMonthCar     Income

      201411               100

      201431               300


      The common key- is YearMonthCar


      when i load the data in qlikview table the data from second row from excel table is missing.


      I understand why because of the join,

      but how do i fix it?