Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
evan_kurowski
Specialist
Specialist

An application to illustrate basic JOIN behavior in QlikView

Greetings Qlikers,

I have created this QlikView application which for my own purposes was intended to help me grasp the various types of SQL JOINS and their syntax and their anticipated renderings within QlikView objects.  I wanted this to help me understand the results in the data model from scripting, and understand what should be displayed in table boxes.

On this application you can see I've illustrated examples of INNER, OUTER, LEFT, RIGHT, JOIN, and an example of WHERE EXISTS in the script and used descriptions on the User Interface to illustrate the results through table boxes.

I thought this might be useful in an educational sense for those of us whom JOIN behavior is either new territory or not completely scoffable yet.  My question is... Do you think this is awesome?  Or am I a lame hoser and my application is stupid and/or lame and me and the application should just skulk away.  ~E

2 Replies
Anonymous
Not applicable

Hello Qlik Community Members- this discussion has was posted previously but accidentally deleted we are recreating the thread. If you have any helpful answers please feel free to respond.

Greg_Williams
Employee
Employee

This is good. Thanks for sharing. Would be helpful to include concatenation of tables as well.

-Greg