Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
danimelo1
Creator
Creator

Outer Join in set analysis

Hello all,

How Can I count the number of persons given the following in set analysis?

2017-12-01_11-57-56.jpg

I was trying this, but it didn't give the results that I need

count( {<Placement-={''}>+<Successor-={''}> }distinct [Person ID])

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

Use the '/' XOR set operator (either A or B, but not both)

Count({<Placement = {''}>/<Successor = {''}>} Distinct [Person ID])

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

4 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Use the '/' XOR set operator (either A or B, but not both)

Count({<Placement = {''}>/<Successor = {''}>} Distinct [Person ID])

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
jonathandienst
Partner - Champion III
Partner - Champion III

Or better,(unless you are explicitly filtering for blanks strings):

Count({<Placement = P(Placement)>/<Successor = P(Successor)>} Distinct [Person ID])

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anil_Babu_Samineni

Seems okay to me, What is the wrong and what are you trying here?

count( {<Placement-={'*'}-{''}>+<Successor-={'*'}-{''}>} distinct [Person ID])

OR

count( {<Placement-={"=Null()"}>/<Successor-={"=Null()"}>} distinct [Person ID])

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
danimelo1
Creator
Creator
Author

This one worked to me!

Count({<Placement = {''}>/<Successor = {''}>} Distinct [Person ID])