This content has been marked as final. Show 5 replies
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:
So, from my perspective data model looks like this:
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