topic Set Analysis totals in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-totals/m-p/1093142#M363383 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am&nbsp; using the below expression to calculate the sum in a text box&nbsp; but it is not returning the correct sum.</P><P>Sum({&lt;[Billing Transaction Datetime]={"&lt;=$(=Timestamp(Today()))"}&gt;}[Billing Disbursement Amount])</P><P>The sum I am getting with this expression is -99 which is incorrect as per the data in below image.</P><P></P><P><IMG alt="ImageTest.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/122577_ImageTest.png" style="height: 269px; width: 620px;" /></P><P>Please help me with the same.</P><P></P><P>Regards,</P><P>Manu</P></BODY></HTML> Mon, 25 Apr 2016 07:26:36 GMT 2016-04-25T07:26:36Z Set Analysis totals https://community.qlik.com/t5/QlikView/Set-Analysis-totals/m-p/1093142#M363383 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am&nbsp; using the below expression to calculate the sum in a text box&nbsp; but it is not returning the correct sum.</P><P>Sum({&lt;[Billing Transaction Datetime]={"&lt;=$(=Timestamp(Today()))"}&gt;}[Billing Disbursement Amount])</P><P>The sum I am getting with this expression is -99 which is incorrect as per the data in below image.</P><P></P><P><IMG alt="ImageTest.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/122577_ImageTest.png" style="height: 269px; width: 620px;" /></P><P>Please help me with the same.</P><P></P><P>Regards,</P><P>Manu</P></BODY></HTML> Mon, 25 Apr 2016 07:26:36 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-totals/m-p/1093142#M363383 2016-04-25T07:26:36Z Re: Set Analysis totals https://community.qlik.com/t5/QlikView/Set-Analysis-totals/m-p/1093143#M363384 <HTML><HEAD></HEAD><BODY><P>What is the correct you are expecting to see? Would you be able to share a sample?</P></BODY></HTML> Mon, 25 Apr 2016 15:44:23 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-totals/m-p/1093143#M363384 sunny_talwar 2016-04-25T15:44:23Z