Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
evan_kurowski
Valued Contributor

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
sli
Valued Contributor II

Re: An application to illustrate basic JOIN behavior in QlikView

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.

Employee
Employee

Re: An application to illustrate basic JOIN behavior in QlikView

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

-Greg

Community Browser