Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I would like to know whether it is possible to keep two table separatedly, but linked (automatically by Qlikview) via key field (same field name) and have the characteristics of a external join.
Like I have table Customer_details (name, address) and Orders.
Table Orders
%KEY_CUST_ID
Order n°
Item
Qty...
Table Customer
%KEY_CUST_ID
Last Name
First Name
Address
Normally an order should have a Customer ID (then we can know his/her name & address) but I would like to manage and show also orders which may not have Customer ID. And I do not want to merge the two tables with the Left join keyword.
Thank you for your explanation
2 (or more) tables associated by qlikview can be managed as you need, you can easily show orders with and without customer id (to help you more attach your document)
Hi
Try some thing like below
if(isNull(%KEY_CUST_ID),Orders)
or
Aggr(if(isNull(%KEY_CUST_ID),Orders),Orders)
Hi all, thank you for your responses. Indeed I made a simple test with 2 tables, one Order with détails, but no Customer ID, when I show data in a table, it shows all records indeed (and display '-' where there is no Customer détails).
So I guess the "automatic" join by field name in Qlikview is a FULL JOIN and not an inner join as I thought
It is a full outer join
Thank you for your confirmation