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?

[jwjackso]

S=1:

If (Count({<S-={'1'}>}D) > 0,D,Null())

S=2:

If (Count({<S-={'2'}>}D) > 0,D,Null())

Suppress Nulls

[Taoufiq_Zarra]

an idea, may be :

=if(isnull(GetFieldSelections(S)),concat({<S={''}>} D,',')
,if(GetFieldSelections(S)=1,concat({<S={"*"}-{'1'}>} D,',')
,if(GetFieldSelections(S)=2,concat({<S={"*"}-{'2'}>} D,',')
)))

result :

No S selected

S=1 selected

s=2 selected

attached qvf file

[elinamcastelletta]

Hello,

Thanks for your reply.

The issue is  there are more than 100 possible values, so I cannot create an If( for each.

Is there a fuction that saves the selected value?

[Taoufiq_Zarra]

in this case :

=if(isnull(GetFieldSelections(S)),concat({<S={''}>} D,',')
,concat({<S={"*"}-{"$(=GetFieldSelections(S))"}>} D,',')
)

[elinamcastelletta]

Hello, it is not working. I need one row by D missing .

I am trying to do it in the script.

Thanks for your help.

[Saravanan_Desingh]

Can u try this?

=Concat({1-$}D,',')

[Saravanan_Desingh]

[elinamcastelletta]

Hello,

Is there a way to avoid using Concat? I need to see each field in a straight table, one per row.

I tried with this but the second part didn't work:

=aggr(if(GetSelectedCount(S)=0,

              only(distinct{<D=E({<S={*}>})>}D),          -------> this works
              only(distinct{$<D=E(1{<S=P(S)>})>}D))    ---------> this doesnt work
    ,D)

Thanks

[Kushal_Chawda]

@elinamcastelletta  try below

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