topic Re: Calculate the Sum in QlikView https://community.qlik.com/t5/QlikView/Calculate-the-Sum/m-p/541337#M202352 <HTML><HEAD></HEAD><BODY><P>Thank you very much Gysbert!</P></BODY></HTML> Thu, 04 Jul 2013 13:11:56 GMT 2013-07-04T13:11:56Z Calculate the Sum https://community.qlik.com/t5/QlikView/Calculate-the-Sum/m-p/541334#M202349 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>i have 3 dates and 3 values. now i want the sum of those values, which are in the interval of 7 weeks of the date.</P><P>my example shows it.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="109"><TBODY><TR><TD class="xl65" height="17" width="71">Date</TD><TD class="xl65" style="border-left: medium none;" width="38">Value</TD></TR><TR><TD class="xl66" height="17" style="border-top: medium none;">16.04.2013</TD><TD class="xl66" style="border-left: medium none; border-top: medium none;">26,84</TD></TR><TR><TD class="xl66" height="17" style="border-top: medium none;">17.05.2013</TD><TD class="xl66" style="border-left: medium none; border-top: medium none;">48,81</TD></TR><TR><TD class="xl66" height="17" style="border-top: medium none;">19.06.2013</TD><TD class="xl66" style="border-left: medium none; border-top: medium none;">706,42</TD></TR></TBODY></TABLE><P></P><P>7 weeks before 19.6 is only 17.05.2013. So i want the sum of 706,42 and 48.81.</P><P>How can i make this? With a if-statement or loop?</P><P></P><P></P><P>Thanks for your&nbsp; help!</P><P></P><P>Best regards,</P><P>Aylin</P></BODY></HTML> Thu, 04 Jul 2013 12:41:16 GMT https://community.qlik.com/t5/QlikView/Calculate-the-Sum/m-p/541334#M202349 2013-07-04T12:41:16Z Re: Calculate the Sum https://community.qlik.com/t5/QlikView/Calculate-the-Sum/m-p/541335#M202350 <HTML><HEAD></HEAD><BODY><P>If you make a date from your Date field you can use set analysis expressions. See attached example.</P></BODY></HTML> Thu, 04 Jul 2013 12:57:25 GMT https://community.qlik.com/t5/QlikView/Calculate-the-Sum/m-p/541335#M202350 Gysbert_Wassenaar 2013-07-04T12:57:25Z Re: Calculate the Sum https://community.qlik.com/t5/QlikView/Calculate-the-Sum/m-p/541336#M202351 <HTML><HEAD></HEAD><BODY><P>Thank you very much Gysbert!</P></BODY></HTML> Thu, 04 Jul 2013 13:11:51 GMT https://community.qlik.com/t5/QlikView/Calculate-the-Sum/m-p/541336#M202351 2013-07-04T13:11:51Z Re: Calculate the Sum https://community.qlik.com/t5/QlikView/Calculate-the-Sum/m-p/541337#M202352 <HTML><HEAD></HEAD><BODY><P>Thank you very much Gysbert!</P></BODY></HTML> Thu, 04 Jul 2013 13:11:56 GMT https://community.qlik.com/t5/QlikView/Calculate-the-Sum/m-p/541337#M202352 2013-07-04T13:11:56Z Re: Calculate the Sum https://community.qlik.com/t5/QlikView/Calculate-the-Sum/m-p/541338#M202353 <HTML><HEAD></HEAD><BODY><P>Thank you very much Gysbert!</P></BODY></HTML> Thu, 04 Jul 2013 13:12:05 GMT https://community.qlik.com/t5/QlikView/Calculate-the-Sum/m-p/541338#M202353 2013-07-04T13:12:05Z Re: Calculate the Sum https://community.qlik.com/t5/QlikView/Calculate-the-Sum/m-p/541339#M202354 <HTML><HEAD></HEAD><BODY><P>Thank you very much!</P></BODY></HTML> Thu, 04 Jul 2013 13:12:19 GMT https://community.qlik.com/t5/QlikView/Calculate-the-Sum/m-p/541339#M202354 2013-07-04T13:12:19Z