topic Cartesian product problem in QlikView

Cartesian product problem

profilejamesbond — Wed, 21 Dec 2022 02:39:51 GMT

Hi,

Scenario: 1 main_product belongs to 1 sub_products (perfect).

I have 1 sub_product that belongs to mutliple main_products (problem -> cartesian product)

I have a main_products table:

I have a sub_products Table:

After left join I see 4 entries:

Now, I have a CFile to check the product availability. The key is "category + sub_category + main" in between "new_table" and "Cfile Applymap"

After Applymap I still see 4 rows because it is true due to all the conditions for the sub_product availability meets.

Now the problem is I see p3 = 4 (sum of items) which should be 2. But It is coming due to cartesian product.

How to solve this problem?

Thanks

Vegar — Wed, 21 Dec 2022 05:50:26 GMT

what if you don't join your product tables? Just keep them as tables in your datamodel.

Without the join you won't get the troubled by the cartesian product.

profilejamesbond — Thu, 22 Dec 2022 06:57:46 GMT

The problem is main_products table "category".

I need this field to check the CFile whether the sub itme meets the criteria or not?

The ideal solution should be:

profilejamesbond — Thu, 22 Dec 2022 08:59:07 GMT

Any help?