Difference in Set Analysis between QV9 and QV10 (bug)

miikkaqlick — Mon, 07 May 2012 10:40:42 GMT

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.

topic Difference in Set Analysis between QV9 and QV10 (bug) in QlikView

Difference in Set Analysis between QV9 and QV10 (bug)