Difference in Set Analysis between QV9 and QV10 (bug)

[miikkaqlick]

Hi!

I should update one of my customers QV9 to QV11. I tried their applications on my computer and noticed that QV10 and QV11 calculates certain kind of set analysis wrong. I have latest releases of QV9, QV10 and QV11 installed (x64). Wrong calculation comes when you use - operand in set analysis.

Here is same chart with same expression and same data on QV11 and on QV9. QV9 is on right and it's correct.

Data:

__________________________________________

Sales:

Load * Inline [

Person,    Category,    Amount

1,    11,    1

1,    12,    2

1,    13,    3

1,    14,    4

2,    12,    3

2,    14,    1

3,    11,    3

4,    13,    2

4,    14,    2

];

PersonCountry:

Load * Inline [

Person,    Country

1,    Finland

2,    Sweden

3,    Denmark

4,    Norway

];

__________________________________________

Expression:

__________________________________________

=Count({

    $<Category = {"11"}>

    -

    $<Category = {"12"}>

    }

Distinct Person)

__________________________________________

I'll also attach file where you can test this.

You can get round this by using E -element function and * operand.