topic Sum selected Months in QlikView https://community.qlik.com/t5/QlikView/Sum-selected-Months/m-p/144867#M23674 <HTML><HEAD></HEAD><BODY><P>Thanks a lot !</P></BODY></HTML> Mon, 25 May 2009 18:56:01 GMT 2009-05-25T18:56:01Z Sum selected Months https://community.qlik.com/t5/QlikView/Sum-selected-Months/m-p/144865#M23672 <HTML><HEAD></HEAD><BODY><P>Hi !</P><P>I have a little problem and hope you can help me. I have some periods an values. When i select a month i like to display the sum of this month with all other periods in this year before. Example:</P><P>When i select May, I need the sum of Jan,Feb;Mar,Apr and May.</P><P>I found a example here in the forum witch is near my problem:</P><P></P><P><A href="http://community.qlik.com/forums/p/16410/64106.aspx#64106">http://community.qlik.com/forums/p/16410/64106.aspx#64106</A></P><BR /><BR /> <P>I have tryed to play around with this formula, but i didnt find the solution.</P><P>I hope you can help me.</P><P>Best regards from Vienna</P><P>Patrick</P><P></P><P></P><P></P></BODY></HTML> Mon, 25 May 2009 14:17:44 GMT https://community.qlik.com/t5/QlikView/Sum-selected-Months/m-p/144865#M23672 2009-05-25T14:17:44Z Sum selected Months https://community.qlik.com/t5/QlikView/Sum-selected-Months/m-p/144866#M23673 <HTML><HEAD></HEAD><BODY><P>Hi, Patrick.</P><P></P><P>try it:</P><P>sum({&lt; Month = {"&lt;=$(=max(Month))"} &gt;} Amount)</P><P>or see in atachment</P></BODY></HTML> Mon, 25 May 2009 18:39:49 GMT https://community.qlik.com/t5/QlikView/Sum-selected-Months/m-p/144866#M23673 sparur 2009-05-25T18:39:49Z Sum selected Months https://community.qlik.com/t5/QlikView/Sum-selected-Months/m-p/144867#M23674 <HTML><HEAD></HEAD><BODY><P>Thanks a lot !</P></BODY></HTML> Mon, 25 May 2009 18:56:01 GMT https://community.qlik.com/t5/QlikView/Sum-selected-Months/m-p/144867#M23674 2009-05-25T18:56:01Z