4 Replies Latest reply: Dec 5, 2012 2:22 AM by Donna Aranzanso RSS

    Primary Key Connections

      Hello,

       

      I just want to ask if this situation is possible in Qlikview.

      I have 2 tables, 1st table consists of the following fields: Entry No. which is the primary key and other details, 2nd table, No. as primary key, From Entry No., To Entry No.

       

      1st table:

       

       

      Field Name
      Entry No (PK)
      other field details..

       

       

      2nd table:

       

      Field Name
      No. (PK)
      From Entry No
      To Entry No

       

      Now to link this two tables, not via No. but via condition.

       

      Condition:

      Entry No >= From Entry No and Entry No <= To Entry No

       

      is this possible in Qlikview?

       

       

      Thanks,

      Donna