6 Replies Latest reply: Aug 23, 2016 7:26 AM by Toni Kautto RSS

    AVG function wrong results

    Nico Gaitan

      Dear all, I am building some bar charts and some metrics throughout AVG function.

      I don't have any missing values in my dataset. The value that I get in Qlik Sense, both in charts and in tables,  is around 89.03, which is a wrong result. The true value is 88.87629904.

      If I export the data to excel and compute the sampling average, I get 88.87629904.

      If I import again this data to Sense I get the true value: 88.87629904.

      This is really weird.

      Any insights?

      Thanks in advance.

      Nico.