# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for
Search instead for
Did you mean:
Creator

## Outer Join in set analysis

Hello all,

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

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

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

1 Solution

Accepted Solutions
Partner

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
4 Replies
Partner

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
Partner

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

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])

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Creator
Author

This one worked to me!

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