how can we join multiple tables in scripting of qlickview
i have to join Customers and Employees with Orders table
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
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!!
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 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.