Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Where PersonSkill exists in RequiredSkill

Hi,

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?

Thank you

3 Replies
luciancotea
Specialist
Specialist

New chart:

-Dimensions: Person, Company

-Expression: =if(PersonSkill = RequiredSkill, PersonSkill)

That might be different, depending on data structure.

Anonymous
Not applicable
Author

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...

msteedle
Luminary Alumni
Luminary Alumni

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.