topic Re: Show values not linked to a selection in App Development

Show values not linked to a selection

elinamcastelletta — Tue, 21 Dec 2021 20:43:45 GMT

Hi, I have 2 tables like below.

I created a dimension within a table. The idea is to show unique D values not linked to S.

1st case when no S selected, 2nd case for S selected:

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

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

How can I fix this?

Expected result:

if I select S=1 I want to see:

Thanks,

sunny_talwar — Thu, 08 Oct 2020 13:00:29 GMT

=Aggr( If(GetSelectedCount(S) = 0, Only({$<D = E({<S={*}>})>} D), Only({$<D = E({<S=P(S)>}), S>}D) ) , D)

elinamcastelletta — Thu, 08 Oct 2020 13:57:50 GMT

Hi, thanks but I doesn't work.