topic Experts - Set Analysis ,Is this expected or BUG ? in QlikView

Experts - Set Analysis ,Is this expected or BUG ?

Fri, 30 Sep 2011 19:23:07 GMT

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.

Experts - Set Analysis ,Is this expected or BUG ?

Fri, 30 Sep 2011 20:53:17 GMT

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

Experts - Set Analysis ,Is this expected or BUG ?

Fri, 30 Sep 2011 21:15:58 GMT

Thanks Stefano!

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

Thanks Again,

Aji Paul.

Experts - Set Analysis ,Is this expected or BUG ?

Fri, 30 Sep 2011 21:38:58 GMT

A001 has CALL but not in 2007...

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

Experts - Set Analysis ,Is this expected or BUG ?

Fri, 30 Sep 2011 22:02:08 GMT

My Bad!

ste.san wrote:
A001 has CALL but not in 2007...
so theres isn't intersection when you select "CALL"