0 Replies Latest reply: Nov 12, 2014 8:42 AM by SOULEIMANE BELARIBI RSS

    One field (tab1) in relation to several fields (tab2)

      HI,

      I have a slightly complex question.
      I have a field in relation to two other fields in the same table.
      as in the following example:

      ISNULL ((SELECT FROM TA.TBL_LIB TABLES WHERE YOUR TA.TBL_ID = 'FC1' AND TA.TBL_CODE T.FC1_CODE =), '') AS C1 Third '
      ISNULL ((SELECT FROM TA.TBL_LIB TABLES WHERE YOUR TA.TBL_ID = 'FC2' AND TA.TBL_CODE T.FC2_CODE =), '') AS C2 Third '

      TBL_ID is in relation with the field FC1_CODE and is also related to the field FC2_CODE.

      How to realize this relationship in Qlikview?

      How to translate this SQL query?

      T: THIRD TABLE
      TA: TABLES TABLE