how can we join multiple tables in scripting of qlickview

[ravireddyk]

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

[robert_mika]

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

[Anonymous]

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!!

[qlikviewwizard]

Hi Ravinder, Did you face any issues in loading

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

[ravireddyk]

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

[qlikviewwizard]

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.

[ravireddyk]

i need result which i attached file !

[qlikviewwizard]

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.

[robert_mika]

This is front end solution consistent of 4 different tabs.

Have you tried to development something yourself?