Experts - Set Analysis ,Is this expected or BUG ?

[#1]

Hello Experts,

I was playing with QV set analysis and I am really excited about it.

(Also concerned about its behavior/ OR my lack of understanding?)

My set is "Anyone who bought DVD in every reporting year"

Count(
{ $<ACCOUNT2=    p({<ORD_YEAR2 = {2007}, PRODUCT2={DVD}  >})*p({<ORD_YEAR2 = {2008}, PRODUCT2={DVD}  >}) *p({<ORD_YEAR2 = {2009}, PRODUCT2={DVD}  >}) *p({<ORD_YEAR2 = {2010}, PRODUCT2={DVD}  >})
*p({<ORD_YEAR2 = {2011}, PRODUCT2={DVD}  >})      
      
  >}
  DISTINCT ACCOUNT2)

This worksgreat!

Now I wouldlike to analyze "how many of them actually called to placed the order" (Please refer to attached QVW)

I have  a field called "Contact Method" with values CALL & MAIL.

The moment I select CALL it eliminates anyone who also had a MAIL order.

Please see attached qvw document.

I am tryingto find out why its eliminating the account which has a MAIL order. OR  in other words trying to understand "SetAnalysis" and how it work with selections.

Would someone please explain what's  going onwith my set analysis?

Thanks inadvance,

Aji Paul.

[#2]

Hi,

if u don't consider a field in your expression it can "interfere".

When u select CALL it's like having this expression:

Count(

{ $<

PRODUCT2 = {DVD},CONTACT_METHOD2={'CALL'}, ACCOUNT2=            p({<ORD_YEAR2 = {2007}, PRODUCT2={DVD},CONTACT_METHOD2={'CALL'}  >})*p({<ORD_YEAR2 = {2008}, PRODUCT2={DVD} ,CONTACT_METHOD2={'CALL'} >}) *p({<ORD_YEAR2 = {2009}, PRODUCT2={DVD} ,CONTACT_METHOD2={'CALL'} >}) *p({<ORD_YEAR2 = {2010}, PRODUCT2={DVD} ,CONTACT_METHOD2={'CALL'} >})

*p({<ORD_YEAR2 = {2011}, PRODUCT2={DVD} ,CONTACT_METHOD2={'CALL'} >})            

  >}

DISTINCT ACCOUNT2)

C u,

Stefano

[#3]

Thanks Stefano!

Would you please explain why it eliminates A001 , even though has "CALL" and other matching criteria to qualify?

Thanks Again,

Aji Paul.

[#4 · Accepted solution]

A001 has CALL but not in 2007...

so theres isn't intersection when you select "CALL"

[#5]

My Bad!

ste.san wrote:

A001 has CALL but not in 2007...

so theres isn't intersection when you select "CALL"