3 Replies Latest reply: Mar 7, 2013 3:17 PM by desiboy520 RSS

    Comparing Two Lists

      Hello Guys,

       

      I am new to qlikview and I need some help. I am trying to compare two lists and both the list have same exact field name. I am trying to compare the one particular field (Meter ID) and see how many records are different from list A. Please see below list for more detail. Please Help!!!!!

       

      List A:

       

      METER_ID

       

      ,
      MODULE_ID,
      PRIME_MCC,
      M_STREET_ADDRESS,
      M_COUNTY,
      SR_NAME,
      P_STREET_ADDRESS,
      P_COUNTY,
      ENTRY_DAT,
      LPT1,
      CAL_DAYS,
      ORIG_DISC,
      LATEST_DI,
      DAU,
      DAU_DAYS,
      M_CITY,
      P_CITY,
      POSS_MTR_COUNT,
      POSS_MTR_ID,
      POSS_MTR_ADD,
      POSS_MTR_ADD_OVER,
      POSS_MTR_CITY,
      ORPHAN_READ,
      Energy,
      CIMS_MFG_CODE,
      EQUIPMENT_NUMBER,
      Issue_Date,
      USER_NAME,
      CIMS_SIZE_CODE,
      Age,
      AvgUsage,
      GPS_LONG,

      GPS_LAT

       

      List B:

       

      METER_ID

       

      ,
      MODULE_ID,
      PRIME_MCC,
      M_STREET_ADDRESS,
      M_COUNTY,
      SR_NAME,
      P_STREET_ADDRESS,
      P_COUNTY,
      ENTRY_DAT,
      LPT1,
      CAL_DAYS,
      ORIG_DISC,
      LATEST_DI,
      DAU,
      DAU_DAYS,
      M_CITY,
      P_CITY,
      POSS_MTR_COUNT,
      POSS_MTR_ID,
      POSS_MTR_ADD,
      POSS_MTR_ADD_OVER,
      POSS_MTR_CITY,
      ORPHAN_READ,
      Energy,
      CIMS_MFG_CODE,
      EQUIPMENT_NUMBER,
      Issue_Date,
      USER_NAME,
      CIMS_SIZE_CODE,
      Age,
      AvgUsage,
      GPS_LONG,

      GPS_LAT