Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
taz803
Contributor III
Contributor III

exluded data from a table

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 )

Labels (6)
2 Replies
Chanty4u
MVP
MVP

Not sure but try thjs 

=Aggr( Only({<Name = {"=IsNull(Match(Name, 'david', 'Paul', 'Pierre'))"}>} Name),    Name)

Gabbar
Specialist
Specialist

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)