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