Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Outer Join?

I'm having some difficulty with the way QV 'joins' logical tables.

I'm loading two fact tables Promotions and Revenue. Promotions have the dimensions Shop and Product. Revenue has Shop, Product and Date as dimensions.

In memory QV joins Promotions and Revenue over the fields Shop and Product. This has an (in this case) undesirable side-effect:

The user wants to select a Promotion and a Date-range to compare Promotion and Revenue, but when a certain Shop/Product combination does not exist in Revenue for the selected Date-range, then Promotions for this combination are not shown either.

As far as I can figure this is caused by the 'natural join' QV creates between the two fact tables. Anyone any idea to circumvent this behavior?

Tags (3)
1 Reply
Contributor III

Outer Join?

can you please post the fields for the tables, I'm having some difficulties with understanding the structure of the fields.

Community Browser