0 Replies Latest reply: May 7, 2012 6:40 AM by Miikka Koskinen RSS

    Difference in Set Analysis between QV9 and QV10 (bug)

    Miikka Koskinen

      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.