Dimension goes Null when I Click a Filter

Thu, 01 Sep 2016 15:03:59 GMT

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.

Re: Dimension goes Null when I Click a Filter

Gysbert_Wassenaar — Fri, 02 Sep 2016 09:07:11 GMT

Post a small qlik sense app that demonstrates the problem.

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

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

topic Dimension goes Null when I Click a Filter in App Development

Dimension goes Null when I Click a Filter

Re: Dimension goes Null when I Click a Filter

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