topic Re: sum between dates in QlikView https://community.qlik.com/t5/QlikView/sum-between-dates/m-p/1294753#M619234 <HTML><HEAD></HEAD><BODY><P>Ah I figured out syntax wasn't the issue. The field I am summing does not have a date link. Only a month. Is there a way to do a sum between first month of the year and the current month?</P></BODY></HTML> Mon, 10 Apr 2017 15:51:46 GMT 2017-04-10T15:51:46Z sum between dates https://community.qlik.com/t5/QlikView/sum-between-dates/m-p/1294751#M619232 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P></P><P>could someone assist with syntax here. I'm trying to sum between the beginning of year to the current date.</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">Sum</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;"> = {</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&gt;=$(vYearStart) &lt;=$(vToday)"</SPAN><SPAN style="font-size: 8pt;">} </SPAN>&gt;} Field)&nbsp;&nbsp; </P><P></P><P><SPAN style="font-size: 8pt;">vYearStart= <SPAN style="color: #0000ff; font-size: 8pt;">YearStart</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Today</SPAN><SPAN style="font-size: 8pt;">())&nbsp; </SPAN></SPAN></P><P><SPAN style="font-size: 8pt;">vToday =<SPAN style="color: #0000ff; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Today</SPAN><SPAN style="font-size: 8pt;">()) </SPAN></SPAN></P><P></P><P></P><P></P><P></P></BODY></HTML> Mon, 10 Apr 2017 15:41:20 GMT https://community.qlik.com/t5/QlikView/sum-between-dates/m-p/1294751#M619232 2017-04-10T15:41:20Z Re: sum between dates https://community.qlik.com/t5/QlikView/sum-between-dates/m-p/1294752#M619233 <HTML><HEAD></HEAD><BODY><P>May be try like this</P><P></P><P><STRONG>Sum({&lt;Date = {"&gt;=$(<SPAN style="color: #ff0000;">=</SPAN>vYearStart) &lt;=$(<SPAN style="color: #ff0000;">=</SPAN>vToday)"}&gt;} Field)</STRONG></P><P></P><P>Also, look here:</P><P><A href="https://community.qlik.com/qlik-blogpost/4394">Dates in Set Analysis</A></P></BODY></HTML> Mon, 10 Apr 2017 15:42:48 GMT https://community.qlik.com/t5/QlikView/sum-between-dates/m-p/1294752#M619233 sunny_talwar 2017-04-10T15:42:48Z Re: sum between dates https://community.qlik.com/t5/QlikView/sum-between-dates/m-p/1294753#M619234 <HTML><HEAD></HEAD><BODY><P>Ah I figured out syntax wasn't the issue. The field I am summing does not have a date link. Only a month. Is there a way to do a sum between first month of the year and the current month?</P></BODY></HTML> Mon, 10 Apr 2017 15:51:46 GMT https://community.qlik.com/t5/QlikView/sum-between-dates/m-p/1294753#M619234 2017-04-10T15:51:46Z Re: sum between dates https://community.qlik.com/t5/QlikView/sum-between-dates/m-p/1294754#M619235 <HTML><HEAD></HEAD><BODY><P>How does your Month field look like?</P></BODY></HTML> Mon, 10 Apr 2017 15:52:47 GMT https://community.qlik.com/t5/QlikView/sum-between-dates/m-p/1294754#M619235 sunny_talwar 2017-04-10T15:52:47Z Re: sum between dates https://community.qlik.com/t5/QlikView/sum-between-dates/m-p/1294755#M619236 <HTML><HEAD></HEAD><BODY><P>Its written out fully</P><P></P><P>January</P><P>February</P><P>March</P><P></P><P>etc</P></BODY></HTML> Mon, 10 Apr 2017 16:00:37 GMT https://community.qlik.com/t5/QlikView/sum-between-dates/m-p/1294755#M619236 2017-04-10T16:00:37Z Re: sum between dates https://community.qlik.com/t5/QlikView/sum-between-dates/m-p/1294756#M619237 <HTML><HEAD></HEAD><BODY><P>And can you share how is this field created in the script? Essentially, is this a date field or not?</P></BODY></HTML> Mon, 10 Apr 2017 16:09:10 GMT https://community.qlik.com/t5/QlikView/sum-between-dates/m-p/1294756#M619237 sunny_talwar 2017-04-10T16:09:10Z