topic Re: Problem with in data giving wrong numbers? in QlikView https://community.qlik.com/t5/QlikView/Problem-with-in-data-giving-wrong-numbers/m-p/1432553#M430729 <HTML><HEAD></HEAD><BODY><P>What combination of dimensions would describe the unique paid amount? ID and Num?</P><P>Then maybe try</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>ID</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>sum([Paid Amount])</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>=Sum(Aggr([Paid Amount], ID,Num))</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#f5f5f5"><TD bgcolor="#f5f5f5"></TD><TD bgcolor="#f5f5f5"><STRONG>600200 </STRONG></TD><TD bgcolor="#f5f5f5"><STRONG>300100 </STRONG></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BBB</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">600200</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">300100</SPAN></TD></TR></TBODY></TABLE><P></P><P>But maybe it's better to remodel your data, so that facts don't get duplicated.</P></BODY></HTML> Tue, 07 Nov 2017 21:15:03 GMT swuehl 2017-11-07T21:15:03Z Problem with in data giving wrong numbers? https://community.qlik.com/t5/QlikView/Problem-with-in-data-giving-wrong-numbers/m-p/1432552#M430728 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a data set where i need to perform few calculations.</P><P></P><P>Due to replicates in data set i am getting wrong numbers for calculations.</P><P></P><P>Please find attached file which has sample data and please help me to resolve the issue.</P><P></P><P>Thanks</P></BODY></HTML> Tue, 07 Nov 2017 20:47:21 GMT https://community.qlik.com/t5/QlikView/Problem-with-in-data-giving-wrong-numbers/m-p/1432552#M430728 qlikuser222 2017-11-07T20:47:21Z Re: Problem with in data giving wrong numbers? https://community.qlik.com/t5/QlikView/Problem-with-in-data-giving-wrong-numbers/m-p/1432553#M430729 <HTML><HEAD></HEAD><BODY><P>What combination of dimensions would describe the unique paid amount? ID and Num?</P><P>Then maybe try</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>ID</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>sum([Paid Amount])</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>=Sum(Aggr([Paid Amount], ID,Num))</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#f5f5f5"><TD bgcolor="#f5f5f5"></TD><TD bgcolor="#f5f5f5"><STRONG>600200 </STRONG></TD><TD bgcolor="#f5f5f5"><STRONG>300100 </STRONG></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">BBB</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">600200</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">300100</SPAN></TD></TR></TBODY></TABLE><P></P><P>But maybe it's better to remodel your data, so that facts don't get duplicated.</P></BODY></HTML> Tue, 07 Nov 2017 21:15:03 GMT https://community.qlik.com/t5/QlikView/Problem-with-in-data-giving-wrong-numbers/m-p/1432553#M430729 swuehl 2017-11-07T21:15:03Z