Say I have 2 tables, Person and Company.
Person has PersonSkill, Company has RequiredSkill.
I want a list of PersonNames and CompanyNames where PersonSkill exists in RequiredSkill
How can I do this? Can it be done in a straight table, or only in the script?
-Dimensions: Person, Company
-Expression: =if(PersonSkill = RequiredSkill, PersonSkill)
That might be different, depending on data structure.
If you rename both PersonSkill and RequiredSkill to Skill, QlikView will do the rest for you automatically. Unless of course you have common fields already. In the latter case you'll get synthetic keys...
I second Michael's solution. Performance would not be good if you add fields from unrelated tables to the same object on the front end, "associating" only through an expression.
Retrieving data ...