Dimension goes Null when I Click a Filter

[#1]

Hello Qlikers! (Is that a thing?)

I'm attempting to make a table comparison between 2 sets of data (lets say Set I and set II).  Both tables use the same dimension. One table has 2 measure fields based only on Set I data, then 3 calculated measures based on a combination of figures from both sets.  The second table has 2 measure fields taken only from Set II data, and one calculated measure, also based only on Set II data.

I would like to apply a filter, coming from a field from Set I (but not displayed on the table), but when I do so, any measure dependent on Set II data goes completely null, as well as the dimension in the second table.  For Example: (where ### refers to some number %%% to a percentage, and Null is...well...self explanatory)

Pre Filter:

Dimension	Measure 1	Measure 2	Measure 3	Measure 4	Measure 5
A	###	###	###	###	%%%
B	###	###	###	###	%%%
C	###	###	###	###	%%%
D	###	###	###	###	%%%
E	###	###	###	###	%%%

Dimension	Measure ABC	Measure DEF	Measure XYZ
A	###	###	%%%
B	###	###	%%%
C	###	###	%%%
D	###	###	%%%
E	###	###	%%%

After Filter Results:

Dimension	Measure 1	Measure 2	Measure 3	Measure 4	Measure 5
B	###	Null	Null	###	Null
C	###	Null	Null	###	Null
E	###	Null	Null	###	Null

Dimension	Measure ABC	Measure DEF	Measure XYZ
Null	0	0	Null

Ideally, I would like the second table to look as follows after the filter is applied:

Dimension	Measure ABC	Measure DEF	Measure XYZ
B	###	###	%%%
C	###	###	%%%
E	###	###	%%%

Where these values would be used in the calculations for Measures 2, 3, and 5 of The first table to fill in the Nulls.  I unfortunately have not found a solution yet myself, hence my presence here.

[Gysbert_Wassenaar]

Post a small qlik sense app that demonstrates the problem.