Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
miikkaqlick
Partner - Creator II
Partner - Creator II

Difference in Set Analysis between QV9 and QV10 (bug)

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.

0 Replies