Discussion Board for collaboration on QlikView Scripting.
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
Go to Solution.
Swuelh's answer is very OK.
However, I would create 2 dimensions: Birth Year and Birth Place.
LOAD ID as ID_Year,
Field2 as [Birth Year]
LOAD ID as ID_Place,
Field2 as [Birth Place]
Try a mapping approach:
Mapping LOAD ID, Text From Table1;
applymap('MAP', BirthYear) as BirthYear,
applymap('MAP', BirthPlace) as BirthPlace
Thank you both for your quick response. I will check out tomorrow and provide feedback.
Both hints worked. Thank you very much.
Tag the answer as correct/usefull to close the discussion then