Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have table1 contient names : david , Paul , Pierre , Eric , Pedro ,Emile , Sadyo
and table2 contient names : david , Paul , Pierre
i want to show : Eric , Pedro ,Emile , Sadyo in a vizualition chart. (without script in load directly in the chart )
Not sure but try thjs
=Aggr( Only({<Name = {"=IsNull(Match(Name, 'david', 'Paul', 'Pierre'))"}>} Name), Name)
I hope in data model both these tables are linked on Field names:-
If there is another Field in table 2 with density 100 percent or a combination of fields with density 100 percent other than field names. Lets name that field FieldA.
try this:-
Aggr(Only({<Names=e({<FieldA={"=(Isnull(FieldA)=0)"}>})>}Names),Names)
or if Field Has Numeric Values then
Aggr(Only({<Names=e({<FieldA={">=0,<=0"}>})>}Names),Names)