topic Re: Chart object sum doubles the values, without sum it is correct but need to sum for multiple records in QlikView https://community.qlik.com/t5/QlikView/Chart-object-sum-doubles-the-values-without-sum-it-is-correct/m-p/1430674#M430403 <HTML><HEAD></HEAD><BODY><P>Try if using distinct qualifier helps, like: =Sum( <STRONG>Distinct</STRONG> Value) . However, if this resolves the issue temporarily, that means your data modelling might have an issue and that should be rectified at the first place.</P></BODY></HTML> Wed, 11 Oct 2017 05:26:04 GMT tresB 2017-10-11T05:26:04Z Chart object sum doubles the values, without sum it is correct but need to sum for multiple records https://community.qlik.com/t5/QlikView/Chart-object-sum-doubles-the-values-without-sum-it-is-correct/m-p/1430673#M430402 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a chart object and it double/triples values at expression when i give Sum(field value). It gives correct value when i give only field value. But, need to sum for multiple rows.</P><P></P><P>Please help.</P></BODY></HTML> Wed, 11 Oct 2017 05:22:54 GMT https://community.qlik.com/t5/QlikView/Chart-object-sum-doubles-the-values-without-sum-it-is-correct/m-p/1430673#M430402 rpavan17 2017-10-11T05:22:54Z Re: Chart object sum doubles the values, without sum it is correct but need to sum for multiple records https://community.qlik.com/t5/QlikView/Chart-object-sum-doubles-the-values-without-sum-it-is-correct/m-p/1430674#M430403 <HTML><HEAD></HEAD><BODY><P>Try if using distinct qualifier helps, like: =Sum( <STRONG>Distinct</STRONG> Value) . However, if this resolves the issue temporarily, that means your data modelling might have an issue and that should be rectified at the first place.</P></BODY></HTML> Wed, 11 Oct 2017 05:26:04 GMT https://community.qlik.com/t5/QlikView/Chart-object-sum-doubles-the-values-without-sum-it-is-correct/m-p/1430674#M430403 tresB 2017-10-11T05:26:04Z Re: Chart object sum doubles the values, without sum it is correct but need to sum for multiple records https://community.qlik.com/t5/QlikView/Chart-object-sum-doubles-the-values-without-sum-it-is-correct/m-p/1430675#M430404 <HTML><HEAD></HEAD><BODY><P>Thank You..</P><P></P><P>It works but it removed few values distant values in sum..</P></BODY></HTML> Wed, 11 Oct 2017 05:35:35 GMT https://community.qlik.com/t5/QlikView/Chart-object-sum-doubles-the-values-without-sum-it-is-correct/m-p/1430675#M430404 rpavan17 2017-10-11T05:35:35Z Re: Chart object sum doubles the values, without sum it is correct but need to sum for multiple records https://community.qlik.com/t5/QlikView/Chart-object-sum-doubles-the-values-without-sum-it-is-correct/m-p/1430676#M430405 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>As you said, the data model might have an issue. How to resolve this.</P></BODY></HTML> Wed, 11 Oct 2017 05:38:01 GMT https://community.qlik.com/t5/QlikView/Chart-object-sum-doubles-the-values-without-sum-it-is-correct/m-p/1430676#M430405 rpavan17 2017-10-11T05:38:01Z Re: Chart object sum doubles the values, without sum it is correct but need to sum for multiple records https://community.qlik.com/t5/QlikView/Chart-object-sum-doubles-the-values-without-sum-it-is-correct/m-p/1430677#M430406 <HTML><HEAD></HEAD><BODY><P>That's difficult to tell without knowing your data and many other aspects of modelling. One quick check - check if you have joined tables in your scripting, and if yes, make sure that at least one of the key fields has unique values in one table?</P></BODY></HTML> Wed, 11 Oct 2017 05:42:34 GMT https://community.qlik.com/t5/QlikView/Chart-object-sum-doubles-the-values-without-sum-it-is-correct/m-p/1430677#M430406 tresB 2017-10-11T05:42:34Z Re: Chart object sum doubles the values, without sum it is correct but need to sum for multiple records https://community.qlik.com/t5/QlikView/Chart-object-sum-doubles-the-values-without-sum-it-is-correct/m-p/1430678#M430407 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have ReportID is unique header ID and which has multiple item level IDs. But, This Report ID repeats for item level as well. So, this ReportID will be unique ID or not?</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 11 Oct 2017 05:44:35 GMT https://community.qlik.com/t5/QlikView/Chart-object-sum-doubles-the-values-without-sum-it-is-correct/m-p/1430678#M430407 rpavan17 2017-10-11T05:44:35Z Re: Chart object sum doubles the values, without sum it is correct but need to sum for multiple records https://community.qlik.com/t5/QlikView/Chart-object-sum-doubles-the-values-without-sum-it-is-correct/m-p/1430679#M430408 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have also observed that few of the rows are not coming to Qlikview from source.</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 11 Oct 2017 06:00:56 GMT https://community.qlik.com/t5/QlikView/Chart-object-sum-doubles-the-values-without-sum-it-is-correct/m-p/1430679#M430408 rpavan17 2017-10-11T06:00:56Z