topic Set analysis: Multiple field selections versus intersection in QlikView

Set analysis: Multiple field selections versus intersection

Mon, 26 Mar 2012 14:33:05 GMT

Hello, can anyone explain to me why the following set analysis code snippets (10SR2) are not equivalent?

Multiple field selections:

{$<Field1= {‘Value1’}, Field2 = {‘Value2’}>}

Intersection:

{$<Field1= {‘Value1’}>*<Field2 = {‘Value2’}>}

Thank you for your help. This has been bothering me for a long time.

Clever_Anjos — Mon, 26 Mar 2012 16:57:09 GMT

Well, IMHO second expression lacks presence of "$" as a parameter.

Maybe {$<Field1= {‘Value1’}>*$<Field2 = {‘Value2’}>}

should return same results

I´m not used wit second type, when I use intersection I generally use on same field.

Mon, 26 Mar 2012 17:50:10 GMT

I am starting to suspect that there is an implicit parameter between field selections, which is the union. Can anyone confirm this?