Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
This is good. Thanks for sharing. Would be helpful to include concatenation of tables as well.
-Greg