Solved: Order of sets in set analysis expression - Qlik Community

Anonymous · ‎2009-07-14

In testing QV9 noticed the following expressions do not do the same thing. Only the first one works as expected in QV9. Am I missing something obvious or does the order now matter? Thanks

Sum

({Set1*$} [Patient Count])

Sum

({$*Set1} [Patient Count])

Anonymous · ‎2009-07-15

Hi Scott,

This is a high priority bug in the GA release of QlikView 9.00.7119 with Intersection in set analysis. It works fine in 8.5 but as you say, changing the set order in v9 changes the result of the calculation.

//JSN

View solution in original post

Report Inappropriate Content · ‎2009-07-15

Logically it should not depend on the order. Because getting intersection doesn't matter on Order of the sets.

Anonymous · ‎2009-07-15

Hi Scott,

This is a high priority bug in the GA release of QlikView 9.00.7119 with Intersection in set analysis. It works fine in 8.5 but as you say, changing the set order in v9 changes the result of the calculation.

//JSN