Qlik Community

QlikView Documents

Documents for QlikView related information.

Joins and Lookups

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

0 Likes
Not applicable

Awesome insights!

0 Likes
Partner
Partner

This is great !!!

0 Likes
Not applicable

Thank you! very helpful.

0 Likes
jtanajewski
New Contributor II

Good info on Lookups.

0 Likes
Not applicable

fair dinkum

0 Likes
khadeer_sparks
Valued Contributor

Great Post

0 Likes
Not applicable

Informative

0 Likes
Not applicable

Very Nice!

0 Likes
michael_maeuser
Contributor III

Very nice

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