Knowledgebase: QODBC
[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 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 made with QuickBooks through "QuickBooks Data" DSN & you can see the list of tables windows list of tables available.

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

Adding data is in progress.

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

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

 

The relationship is automatically added between Customer & Invoice table.

 

Please click on join icon to see relationship details.

 

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

 

Please click "Load data" button for loading data in the QlikSense Desktop.

Loading data is in progress.

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

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

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

QlikSense Desktop displaying 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).