Qlik Community

QlikView Documents

Documents for QlikView related information.

Joins and Lookups

Employee
Employee

Joins and Lookups

This document concerns data modelling and joins

  • What is the difference between a join using the join prefix and a join using a SELECT statement?
  • When should you join and when shouldn't you? Performance considerations?
  • Are there alternatives to joins? (Yes! Applymap!)
  • What does the Keep prefix do?

HIC

See also my blog post on the same subject: To Join or not to Join.

Labels (1)
Comments
MVP
MVP

Well done, very informative!

Thanks,

Stefan

Not applicable

Awesome insights!

phaneendra_kunc
Valued Contributor III

This is great !!!

Not applicable

Thank you! very helpful.

jtanajewski
New Contributor

Good info on Lookups.

Not applicable

fair dinkum

khadeer_sparks
Valued Contributor

Great Post

Not applicable

Informative

Not applicable

Very Nice!

michael_maeuser
Contributor III

Very nice

Version history
Revision #:
1 of 1
Last update:
‎09-12-2012 08:01 AM
Updated by:
Employee