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?
Thanks, but it also doesn't work. I tried with =getfieldselections before too, but didn't get correct results in Qlik Sense.
@elinamcastelletta try below then
=if(GetSelectedCount(S)=0,
only({<D=E({<S={"*"}>})>}D),
Only({<S={"*"}-{"$(=concat(distinct S,','))"}>+<S,D=E({<S={"*"}>})>}D))
Hi Kush,
It is not working either. It gives back all the values, not the missing ones.
Thanks