Inner Join In QlikView Applications

Introduction

The inner join in a QlikView application is automatic. The inner join is that common field names between two tables. The inner join can be used to select all rows from both tables if there is a match between the columns in both tables.

The following are the uses of Inner Joins in a QlikView Application:

  • The inner join can be used to create a new result table by combining two tables based upon the join-predicate.
  • There is no field in common that will render a Cartesian product.
  • If the user does not specify the table name when joining then QlikView considers the previously loaded logical table.
  • In QlikView, the inner join will always keep the first table name and ignores the second table name.

How an Inner Join works In QlikView Applications

The following is the basic procedure for using an Inner Join.

Step 1: Open the QlikView Application: In the first step we need to open the QlikView and go to File-> New. This window will then be opened.

After clicking New option

Step 2: Open Edit Script Window:
The next step is we to open the edit script window from File-> Edit Script. This window will then be opened.

Window of edit script

Step 3: Open the table files:
The next step is to open the table files and open our Excel file and click on the Open button.

table files

Step 4: Open File Wizard Type: After opening the Excel file the file wizard type window will be opened; click on the "Next" button.

file wizard type

Step 5: Open File Wizard Transform: After the file wizard type window this window will be opened and click on the "Next" button.

Enable Transformation

Step 6:
Open File Wizard Options: After the file wizard type window this window will be opened and click on the Finish button.

file wizard options

Step 7: Write code in Edit Script and Reload it:
The next step is write the code in the edit script and reload it.

code script

Step 8:
After reloading the edit script this window will be opened and click on the OK button.

personal edition

Step 9: Save the file:
The next step is to save our QlikView file with the extension .qvw and click on the Save button.

save file

Step 10: Sheet Property Window:
After saving the file the next step is to select the field from the sheet property window and click on the OK button.

select field

Step 11: Main Window: This window will show the table of an Excel sheet that you have imported into the table files.

main window

Then again, following this process we need to import the second Excel file and write this code in the edit script and reload it.

code script1


Step 12: Sheet Property Window:
After saving the file the next step is to select a field from the sheet property window and click on the OK button.

select field1


Step 13: Main Window
: This window will show the table of the Excel sheet that you have imported into the table files.

main1window


Step 14: Code of Inner Join:
Now again we open the edit script and write the code of the inner join and reload it.

inner join


Step 15 :
Sheet Property Window: After saving the file the next step is to select a field from the sheet property window and click on the OK button.

select field2


Step 16: Final Window
: This window will show the final window of the inner join.

final window


Step 17: Table viewer: After clicking on the table viewer it opens the table view of the inner join.

table view

Then, the following is the final window.

inner window


 So this final window will show the common field between two tables.

Summary

This article describes how inner joins work in QlikView applications.