Qlik Community

QlikView Documents

QlikView documentation and resources.

Announcements
Document boards are being consolidated, this board no longer allows NEW documents READ MORE

Joins and Lookups

cancel
Showing results for 
Search instead for 
Did you mean: 
Henric_Cronström

Joins and Lookups

Attachments

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
sakamsureshbabu
Creator
Creator

good

0 Likes
cheburashka
Creator III
Creator III

Great post! Clear explanation and comparison of different concepts.

0 Likes
rajkumarb
Creator II
Creator II

Thank you! very helpful.

0 Likes
Not applicable

Hi hic,

I'm new to qlikview:

I have a doubt regarding Loading.

I Load the data and later I deleted the script and reloaded the data. It's fine the table related to previous load disappear from the datamodel. My doubt is the qlikview application still holds that table or is deleted in the reload. If it retained with the application then how can i get that table's information? is QVD creation is possible with that table If it exists with the application?

0 Likes
Not applicable

Very Helpful indeed.

0 Likes
clondono
Creator III
Creator III

Thank you for sharing!

0 Likes
joris_lansdaal
Creator
Creator

Thank you Henric. I regularly visit read your documents for help and inspiration.

0 Likes
elpmasjj
Contributor II
Contributor II

This document was invaluable for me as a beginner. It really sets you on a good starting path.

0 Likes
mgranillo
Specialist
Specialist

The most important part of the article for me was the following: "The association can be evaluated to a left join or a right join depending on where the user has made a selection. And with no selection, the association is always evaluated to a full outer join."  Just seeing that functionality verbalized was very helpful

0 Likes
aquariansp69
Contributor
Contributor

Very good information on lookups. Thanks so much and well done!!!

~Sambhu

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