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.
