Knowledgebase
[QODBC-Desktop] How to Auto Add relationship Between two tables in QlikSense Desktop using QODBC
Posted by Jack - QODBC Support on 26 December 2017 10:19 AM

How to Auto Add relationship Between two tables in QlikSense Desktop using QODBC

Problem Description:

How to Auto Add relationship Between two tables in QlikSense Desktop using QODBC?

Solution:

Please create a new application in QlikSense Desktop & connect to QuickBooks Data through QODBC. Please refer to How to use QlikSense Desktop with QODBC for connection detail.

I am assuming that you have referred above link & connected to QuickBooks from QlikSense Desktop using QODBC.

The connection was made with QuickBooks through "QuickBooks Data" DSN & you can see the list of tables and windows list of tables available.

Select the table you want to add to the QlikSense Desktop & click the "Add data" button. In this example, I am selecting the Customer & Invoice table.

Adding data is in progress.

The Customer & Invoice table data is added to the QlikSense Desktop.

Please click the Relationship icon to associate table data according to the recommendation.

 

The relationship is automatically added between the Customer & Invoice table.

 

Please click on the join icon to see the relationship details.

 

You can see that the Customer table's "ListID" is related to the Invoice table's "CustomerRefListID" field.

 

Please click the "Load data" button on the QlikSense Desktop.

Loading data is in progress.

The data is loaded successfully. Click on the "Edit the sheet" button to add data to the sheet.

The empty sheet is open in the QlikSense Desktop. Click on the "Fields" icon to add table fields to the sheet.

In this example, I have added the Customer table's Phone, Email field & Invoice table's CustomerRefFullName, RefNumber, and SubTotal field in the sheet. Please click on the "Done" button to finish editing the sheet.

QlikSense Desktop displays data in the sheet.

Now, You can perform any operation on table data using QlikSense Desktop.

 

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).