Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
S=1:
If (Count({<S-={'1'}>}D) > 0,D,Null())
S=2:
If (Count({<S-={'2'}>}D) > 0,D,Null())
Suppress Nulls
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
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?
in this case :
=if(isnull(GetFieldSelections(S)),concat({<S={''}>} D,',')
,concat({<S={"*"}-{"$(=GetFieldSelections(S))"}>} D,',')
)
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.
Can u try this?
=Concat({1-$}D,',')
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
@elinamcastelletta try below
=if(GetSelectedCount(S)=0,
only(distinct{<D=E({<S={*}>})>}D),
Only({<S={"*"}-{"$(=getfieldselections(S))"}>+<S,D=E({<S={"*"}>})>}D))