Effects of using the same field in SetAnalysis

[jwjackso]

I had a user ask which Set Analysis formula to use if they wanted Val >=6 and <12.  They had tried {<Val={"<12"},Val={">=6"}>} and {<Val={"<12>=6"}>}.  I was surprised at the results.

[Digvijay_Singh]

I think Same field in one set is giving unpredictable results, better to use other operators  in case needed to use same field in multiple conditions. Below expression gives the intersection set -

Count({<Val={"<12"}>*<Val={">=6"}>}Val)

[jwjackso]

I agree, the normal interpretation of {<Field1={"<12"},Field2={"<=6"} >}is an "AND" test.  It appears that {<Field1={"<12"},Field1={">=6"}>} is unpredictable.