topic Re: An application to illustrate basic JOIN behavior in QlikView in QlikView

An application to illustrate basic JOIN behavior in QlikView

evan_kurowski — Tue, 15 Apr 2014 20:29:51 GMT

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

Re: An application to illustrate basic JOIN behavior in QlikView

Anonymous — Tue, 15 Apr 2014 20:30:35 GMT

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.

Re: An application to illustrate basic JOIN behavior in QlikView

Greg_Williams — Tue, 15 Apr 2014 20:41:55 GMT

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

-Greg