2 Replies Latest reply: Sep 15, 2016 1:50 PM by Santiago Respane RSS

    How to link tables the way I want them to link?

    jacob meredith

       

      Here is part of my script I loaded into Qlikview:

       

      SQL SELECT DESCRIPTION,
      IDENTIFIER,
      "PMID_H0",
      "MS_STATUSID",
      MID
      FROM IKSDB.TBEQUIPMENT
      Where (
      "MS_STATUSID" = '14');

      SQL SELECT MSID,
      MID,
      STATUSID
      FROM IQREVDB.TBMSTRATEGY
      Where (STATUSID = '6');

      SQL SELECT MSID,
      TITLE,
      "CP_TASK",
      "CP_TASK_DESC",
      "CP_TASK_FREQ",
      "CP_TASK_FREQ_UNITID",
      TASKTYPE,
      "TASK_FREQ",
      "TASK_FREQ_UNIT_ID" as "UNIT_ID"
      FROM IQREVDB.TBMSTRATEGYTASKS;

      SQL SELECT "UNIT_ID",
      UNIT,
      DESCRIPTION,
      "DAYS_CONVERTED"
      FROM IQREVDB.TBUNITS;

       

      I want the tables to link the tables by MID, MSID, and "UNIT_ID". When I load this script, Qlikview automatically links MID, MSID, and DESCRIPTION. What do I need to do to accomplish this? I got the links I wanted when I commented-out one of the DESCRIPTIONS, but that takes away from my data...