2 Replies Latest reply: Sep 3, 2014 7:42 AM by Peter Weber RSS

    Wrong Result in Aggr-Function

      Hey all,


      I have a problem conerning the aggr function. I have a number of keys and over the keys I want to sum the audience.

      The problem is that I don't get the exact value in QlikView.


      This is the right number in Excel:



      And this is the result in QlikView:


      The formula I use for calculation is:

           =Sum(Aggr(Sum(Distinct "audience (in mio) 14+ [adults]"), Keys))


      It seems that QlikView calculates more values than it should do. But when I do a "Count(Distinct keys)", I get the right number of keys. That's why I'm confused and I can't figure out the error.


      I have attached the Excel file and the QlikView file. I hope someone can help me!


      Kind regards


        • Re: Wrong Result in Aggr-Function
          Manish Kachhia

          QlikView is giving Correct Result as there are duplicate Keys in your excel file which is not giving correct results...




          For the First Record, There are two Values Exists...0.13 and 0.05, But your Excel is only Considering 0.13... The same happenning with above all shown Keys...


          Hope this will clear your doubt...