issue - Left join becomes Cartesian Production

Thu, 14 Aug 2014 17:24:46 GMT

Hi all,

I have below issue.

below is the descriptions.

I have two table like below,

both contains product.

Table 1 contains all products.

Table 2 contains product which was bought by customer.

I would like to left join Table 1 with Table 2.

I would like to add flag field which indicates product was bouth by customer or not.

below is the example.

NoConcatenate

Table1:

Load

Product

Resident T1;

NoConcatenate

Table2:

Load

Product

Resident BoughtByCust;

I am trying below.

but not getting desired results and it shows cartesian product.

NoConcatenate

Table3:

Load

resident Table1;

left join

Load

resident Table2;

I would like to get below output.

Product (From T1) Product(from BoughtByCust) Flag

ABC ABC Y

DEF DEF Y

GHI - N <-- this product was not exist in BoughtByCust table so it should show N in flag field.

how can we achive like above ?

any help ?

Thanks!.

Re: issue - Left join becomes Cartesian Production

marcus_sommer — Thu, 14 Aug 2014 19:01:51 GMT

Joins are often not neccessary in qlikview. Why do you used not sales as fact-table and products as dimension-table in your datamodel. The most calculations could be done in gui-objects and if you used an additional product-field beside your product-key like product as ProductFromSales you could differentiate and decide from which table you takes your field.

- Marcus

topic issue - Left join becomes Cartesian Production in QlikView

issue - Left join becomes Cartesian Production

Re: issue - Left join becomes Cartesian Production