Show missing values

[elinamcastelletta]

Hello,

I need to get the values from D which are not assigned to a field in S:

S	A	D
1	x	x1
1	x	x2
1	b	b3
2	b	b4
2	x	x5
	x	x6
	x	x7

Example:

- No S selected. Result --> x6, x7 -Done: if( isnull(S),D)

-S=1 selected. Result -->b4,x5,x6,x7  - How do I show this result?

-S=2 selected. Result --> x1,x2,b3,x6,x7 - How do I show this result?

[elinamcastelletta]

Hello,

I need to get the values from D which are not assigned to a field in S:

S	A	D
1	x	x1
1	x	x2
1	b	b3
2	b	b4
2	x	x5
	x	x6
	x	x7

Example:

- No S selected. Result --> x6, x7 -Done: if( isnull(S),D)

-S=1 selected. Result -->b4,x5,x6,x7  - How do I show this result?

-S=2 selected. Result --> x1,x2,b3,x6,x7 - How do I show this result?

[elinamcastelletta]

Thanks, but it also doesn't work. I tried with =getfieldselections before too, but didn't get correct results in Qlik Sense.

[Kushal_Chawda]

@elinamcastelletta  try below then

=if(GetSelectedCount(S)=0,
only({<D=E({<S={"*"}>})>}D),
Only({<S={"*"}-{"$(=concat(distinct S,','))"}>+<S,D=E({<S={"*"}>})>}D))

[elinamcastelletta]

Hi Kush,

It is not working either. It gives back all the values, not the missing ones.

Thanks