topic Outer Join in set analysis in QlikView

Outer Join in set analysis

danimelo1 — Fri, 01 Dec 2017 11:50:32 GMT

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

jonathandienst — Fri, 01 Dec 2017 12:00:39 GMT

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

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

jonathandienst — Fri, 01 Dec 2017 12:02:31 GMT

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

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

Anil_Babu_Samineni — Fri, 01 Dec 2017 12:20:07 GMT

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

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

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

danimelo1 — Fri, 01 Dec 2017 16:52:43 GMT

This one worked to me!

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