topic How i do this sum in QlikView https://community.qlik.com/t5/QlikView/How-i-do-this-sum/m-p/233312#M84849 <HTML><HEAD></HEAD><BODY><P>1. Make a variable: V_MAXCOMPTSIAB = MAX(COMPT_SIAB)</P><P>2. Use the variable like that:</P><P>SUM({$&lt;COMPT_SIAB=(#V_MAXCOMPTSIAB)&gt;}NASCIDOS_VIVOS)</P><P></P><P>i hope that works ...</P></BODY></HTML> Thu, 05 Nov 2009 19:58:05 GMT ManuelRühl 2009-11-05T19:58:05Z How i do this sum https://community.qlik.com/t5/QlikView/How-i-do-this-sum/m-p/233311#M84848 <HTML><HEAD></HEAD><BODY><P>I have a field in table named COMPT_SIAB this filled with date i need sum field NASCIDOS_VIVOS when date is last date in table i try this but dont work.. please i need help</P><P>SUM({$&lt;COMPT_SIAB=MAX(COMPT_SIAB)&gt;}NASCIDOS_VIVOS)</P></BODY></HTML> Thu, 05 Nov 2009 19:38:30 GMT https://community.qlik.com/t5/QlikView/How-i-do-this-sum/m-p/233311#M84848 2009-11-05T19:38:30Z How i do this sum https://community.qlik.com/t5/QlikView/How-i-do-this-sum/m-p/233312#M84849 <HTML><HEAD></HEAD><BODY><P>1. Make a variable: V_MAXCOMPTSIAB = MAX(COMPT_SIAB)</P><P>2. Use the variable like that:</P><P>SUM({$&lt;COMPT_SIAB=(#V_MAXCOMPTSIAB)&gt;}NASCIDOS_VIVOS)</P><P></P><P>i hope that works ...</P></BODY></HTML> Thu, 05 Nov 2009 19:58:05 GMT https://community.qlik.com/t5/QlikView/How-i-do-this-sum/m-p/233312#M84849 ManuelRühl 2009-11-05T19:58:05Z How i do this sum https://community.qlik.com/t5/QlikView/How-i-do-this-sum/m-p/233313#M84850 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>here are an example that hopefully helps to solve your requirement.</P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Thu, 05 Nov 2009 20:06:57 GMT https://community.qlik.com/t5/QlikView/How-i-do-this-sum/m-p/233313#M84850 2009-11-05T20:06:57Z How i do this sum https://community.qlik.com/t5/QlikView/How-i-do-this-sum/m-p/233314#M84851 <HTML><HEAD></HEAD><BODY><P>i dont understand your question but try to check the attached file and see if it help.</P></BODY></HTML> Thu, 05 Nov 2009 20:15:19 GMT https://community.qlik.com/t5/QlikView/How-i-do-this-sum/m-p/233314#M84851 2009-11-05T20:15:19Z