3 Replies Latest reply: Oct 12, 2012 1:16 AM by Sivasankar Kanagasabai RSS

    Sync keys issue

      Dear All,

       

      I have following scenerio,

       

      Users:

      load * inline [

      userid, username

      1, 'UserOne'

      2, 'UserTwo'

      3, 'UserThree'] ;

       

      Opportunity:

      load * inline [

      opportunityid, userid, date

      1, 1, '10/10/2012'

      2, 1, '10/10/2012'

      3, 1, '10/10/2012'

      4, 2, '10/10/2012'

      5, 2, '10/10/2012'

      6, 3, '10/10/2012'] ;

        

      Lead:

      load * inline [

      leadid, userid, date

      1, 1, '10/10/2012'

      2, 1, '10/10/2012'

      3, 1, '10/10/2012'

      4, 2, '10/10/2012'

      5, 2, '10/10/2012'

      6, 3, '10/10/2012'] ;

       

      Order:

      load * inline [

      orderid, userid, date

      1, 1, '10/10/2012'

      2, 1, '10/10/2012'

      3, 1, '10/10/2012'

      4, 2, '10/10/2012'

      5, 2, '10/10/2012'

      6, 3, '10/10/2012'] ;

       

      Calendar:

      Load * Inline [

      date, year, month

      '10/10/2012', '2012', '10'

      ]

       

      Below is the Syn key shown. how can i remove sync key and be able to select data by both date and userid

      qlikview.png

       

      Kind Regards,

      Muhammad Naveed