Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
ravireddyk
New Contributor III

how can we join multiple tables in scripting of qlickview

how can we join multiple tables in scripting of qlickview

i have to join Customers and Employees with Orders table

          

        

Customers
CustomerID
Customer
CustomerContactName
CustomerCountry
Customeraddress
CustomerCity
CustomerPhone
Orders
CustomerID
EmployeeID
OrderID
ProductID
Product
OrderDate
Year
Month
Week
Margin
Sales
Cost
Quantity
Employees
EmployeeID
Salesrep
8 Replies
Highlighted

Re: how can we join multiple tables in scripting of qlickview

Just load all 3 tables.

Qlikview will join them automatically as you have key fields already

Your Orders table have CustomerID -same as your Customers table

and Employees table will be join to Orders on EmployeeID field

Highlighted
qlikviewnovice
Valued Contributor II

Re: how can we join multiple tables in scripting of qlickview

Hi,

Load all 3 tables, Qlikview will join them automatically when we have key fields. In this scenario we have key fields Customer ID, Employee ID so it will join automatically.

Hope it helps!!

Highlighted
qlikviewwizard
Honored Contributor II

Re: how can we join multiple tables in scripting of qlickview

Hi Ravinder, Did you face any issues in loading

.If you follows our other folks advise, you won't get any issue.

Highlighted
ravireddyk
New Contributor III

Re: how can we join multiple tables in scripting of qlickview

Is that required any kind of join condition should be used.but hou can be calculated in rader chart for sales,pie char for country sales and line chart for annual sales what will be the expressions

Highlighted
qlikviewwizard
Honored Contributor II

Re: how can we join multiple tables in scripting of qlickview

Qlikview is an associate datamodel. If you can able to build the datamodel, you can create measure in front-end.

Or else you can create measures in scripting level itself.

Please attach the sample file and required output to demonstrate your requirement. Thank you.

Hope it will Helpful to you.

Highlighted
ravireddyk
New Contributor III

Re: how can we join multiple tables in scripting of qlickview

i need result which i attached file !Sales.png

Highlighted
qlikviewwizard
Honored Contributor II

Re: how can we join multiple tables in scripting of qlickview

I didn't see any attachment but a screen shot.

Your screen shows high level.

Please attach the sample qvw if possible to demonstrate your requirement. Thank you.

Highlighted

Re: how can we join multiple tables in scripting of qlickview

This is front end solution consistent of 4 different tabs.

Have you tried to development something yourself?