topic Linked table via key field and keep left join characteristics in QlikView

Linked table via key field and keep left join characteristics

Mon, 14 Jul 2014 13:39:41 GMT

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

Re: Linked table via key field and keep left join characteristics

alexandros17 — Mon, 14 Jul 2014 13:42:35 GMT

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)

Re: Linked table via key field and keep left join characteristics

sasikanth — Mon, 14 Jul 2014 14:07:12 GMT

Try some thing like below

if(isNull(%KEY_CUST_ID),Orders)

Aggr(if(isNull(%KEY_CUST_ID),Orders),Orders)

Re: Linked table via key field and keep left join characteristics

Mon, 14 Jul 2014 14:38:19 GMT

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

Re: Linked table via key field and keep left join characteristics

alexandros17 — Mon, 14 Jul 2014 15:00:50 GMT

It is a full outer join

Re: Linked table via key field and keep left join characteristics

Mon, 14 Jul 2014 15:47:04 GMT

Thank you for your confirmation