1 Reply Latest reply: Jul 13, 2014 11:51 PM by Satyadev Jaiswal RSS

    Data variance in Qlikview

      Hi,

       

      I noticed some variances in my source data against Qlik's, Qlik is wrong, but only for selected few, most of the others are okay, and best of all, the total aggreated total is correct........really puzzling.

       

      Below snapshot, top is  customer's current month sales total, and the bottom table is from the source data in MS Access for same month & year.   Any advice? Thank you.

       

      Formula is : sum([ACTUAL_SALES_AMT(JPY)])

      Capture.JPG

       

      Capture1.JPG

       

      Capture2.JPG