Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

View solution in original post

4 Replies
jonathandienst
Partner
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
jonathandienst
Partner
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
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])

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)
danimelo1
Creator
Creator
Author

This one worked to me!

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