Qlik Community

QlikView Documents

QlikView documentation and resources.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW

Joins and Lookups

Henric_Cronström

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)
Attachments
Comments
swuehl
MVP
MVP

Well done, very informative!

Thanks,

Stefan

0 Likes
Not applicable

Awesome insights!

0 Likes
phaneendra_kunc
Partner
Partner

This is great !!!

0 Likes
Not applicable

Thank you! very helpful.

0 Likes
jtanajewski
Contributor II
Contributor II

Good info on Lookups.

0 Likes
Not applicable

fair dinkum

0 Likes
khadeer_sparks
Specialist
Specialist

Great Post

0 Likes
Not applicable

Informative

0 Likes
Not applicable

Very Nice!

0 Likes
michael_maeuser
Partner
Partner

Very nice

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