Qlik Community

QlikView Documents

QlikView documentation and resources.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING

Joins and Lookups

cancel
Showing results for 
Search instead for 
Did you mean: 
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
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: