Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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
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!!
Hi Ravinder, Did you face any issues in loading
.If you follows our other folks advise, you won't get any issue.
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
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.
i need result which i attached file !
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.
This is front end solution consistent of 4 different tabs.
Have you tried to development something yourself?