topic Re: How to Sum excluding dates? in QlikView https://community.qlik.com/t5/QlikView/How-to-Sum-excluding-dates/m-p/431968#M161043 <HTML><HEAD></HEAD><BODY><P>try this</P><P>sum({&lt; <SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">DATEFINANCIAL</SPAN> = e() &gt;} <SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;"> UNITS_INVENT</SPAN>)</P></BODY></HTML> Wed, 13 Feb 2013 10:59:41 GMT er_mohit 2013-02-13T10:59:41Z How to Sum excluding dates? https://community.qlik.com/t5/QlikView/How-to-Sum-excluding-dates/m-p/431966#M161041 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a calendar with a DATEFINANCIAL as a key, with this, I have a calendar slider, etc, but I want to do a calculation excluding the dates, for example:</P><P></P><P>I selected to see the year 2012 and December, and the sum of units = 100, but I want to knot, how many units has been sold till today=1000</P><P></P><P>I did this function but it does not works :&nbsp; Sum({&lt;DATEFINANCIAL= &gt;}&nbsp; UNITS_INVENT )</P><P></P><P>Thank's guys!!</P></BODY></HTML> Wed, 13 Feb 2013 10:54:33 GMT https://community.qlik.com/t5/QlikView/How-to-Sum-excluding-dates/m-p/431966#M161041 ecabanas 2013-02-13T10:54:33Z Re: How to Sum excluding dates? https://community.qlik.com/t5/QlikView/How-to-Sum-excluding-dates/m-p/431967#M161042 <HTML><HEAD></HEAD><BODY><P>You need to clear the fields you or your user made the selections in, I am assuming Year and Month:</P><P></P><P>Sum({&lt;YEAR=, MONTH= &gt;}&nbsp; UNITS_INVENT )</P></BODY></HTML> Wed, 13 Feb 2013 10:58:19 GMT https://community.qlik.com/t5/QlikView/How-to-Sum-excluding-dates/m-p/431967#M161042 swuehl 2013-02-13T10:58:19Z Re: How to Sum excluding dates? https://community.qlik.com/t5/QlikView/How-to-Sum-excluding-dates/m-p/431968#M161043 <HTML><HEAD></HEAD><BODY><P>try this</P><P>sum({&lt; <SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">DATEFINANCIAL</SPAN> = e() &gt;} <SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;"> UNITS_INVENT</SPAN>)</P></BODY></HTML> Wed, 13 Feb 2013 10:59:41 GMT https://community.qlik.com/t5/QlikView/How-to-Sum-excluding-dates/m-p/431968#M161043 er_mohit 2013-02-13T10:59:41Z Re: How to Sum excluding dates? https://community.qlik.com/t5/QlikView/How-to-Sum-excluding-dates/m-p/431969#M161044 <HTML><HEAD></HEAD><BODY><P>thank's!!!! it works!!!!!</P><P></P><P>Eduard</P></BODY></HTML> Wed, 13 Feb 2013 11:41:24 GMT https://community.qlik.com/t5/QlikView/How-to-Sum-excluding-dates/m-p/431969#M161044 ecabanas 2013-02-13T11:41:24Z