5 Replies Latest reply: Dec 8, 2013 10:31 AM by Fabrice Aunez RSS

    Data model

      Dear community,

       

      I am Qlikview newbie and have some trouble with the data model of our CRM-database which is the source for my Qlikview analysis:

       

      In the first table I have 2 columns: ID and text. The other table contains data with a link to the ID. For better understanding I enclosed two pictures:

      Text.jpg     Data.jpg

      So, from my perspective data model looks like this:

      table structure.jpg

       

      The columns "Birth Year" and "Birth Place" have links to the same column in table 1. How do I set up this in the script (or elsewhere) so that I do not see anymore "1" but "1981"?

       

      Unfortunately data cannot be changed

       

      Thank you very much