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

    multiple relationship

      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_Tiers'
      ISNULL ((SELECT FROM TA.TBL_LIB TABLES WHERE YOUR TA.TBL_ID = 'FC2' AND TA.TBL_CODE T.FC2_CODE =), '') AS 'C2_Tiers'

      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: Tiers TABLE
      TA: Tables TABLE