5 Replies Latest reply: Oct 12, 2011 1:51 PM by Kiran Rokkam RSS

    SQL Keys in QV LOAD

      Hi guys,

       

      I was wondering if there is any possibility to create keys like in database architectures? If so, where can I retrieve this information? I can't seem to find it anywhere.

       

      Thanks,

      asolsson

        • SQL Keys in QV LOAD
          Anand Chouhan

          Hi,

           

          As i understand you ask about Primarykeys,Composite keys, cascade keys, forighn keys etc if so for this i say

          1. when there is a key which is connected with any table is called as key like

           

          Table1 key

           

          ID as Key

           

          Table2 key

           

          ID-Info as Key

           

          which is directly connected to each othere and its frequency is equal in qlikview and is a unique keys and if you want to create a composite key you can create with combination of two keys like

           

          Key1&'-'&Key 2 as CompositeKey

           

           

          Rgds

          Anand