topic Re: set analysis Logic in QlikView https://community.qlik.com/t5/QlikView/set-analysis-Logic/m-p/647748#M1062634 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this. Hope it works...</P><P></P><P>sum ({$&lt;Date&lt;={'2014-01-31'}&gt;} amount)</P></BODY></HTML> Fri, 19 Sep 2014 10:26:23 GMT 2014-09-19T10:26:23Z set analysis Logic https://community.qlik.com/t5/QlikView/set-analysis-Logic/m-p/647745#M1062631 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">I want to write this logic in set analysis</SPAN></P><P> </P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;"> &lt;= '2014-01-31',</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">amount</SPAN><SPAN style="font-size: 8pt;">)) </SPAN></P><P> </P><P><SPAN style="font-size: 8pt;">kindly help</SPAN></P><P></P></BODY></HTML> Fri, 19 Sep 2014 10:20:13 GMT https://community.qlik.com/t5/QlikView/set-analysis-Logic/m-p/647745#M1062631 abhaysingh 2014-09-19T10:20:13Z Re: set analysis Logic https://community.qlik.com/t5/QlikView/set-analysis-Logic/m-p/647746#M1062632 <HTML><HEAD></HEAD><BODY><P>SUM({&lt;Date = {'&lt;=$(=MonthEnd(YearStart(Today())))'}&gt;}Amount)</P></BODY></HTML> Fri, 19 Sep 2014 10:24:20 GMT https://community.qlik.com/t5/QlikView/set-analysis-Logic/m-p/647746#M1062632 MK_QSL 2014-09-19T10:24:20Z Re: set analysis Logic https://community.qlik.com/t5/QlikView/set-analysis-Logic/m-p/647747#M1062633 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P>=<SPAN style="color: #0000ff;">Sum</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Date={"</SPAN><SPAN style="font-size: 8pt;"> &lt;= 2014-01-31"}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">amount</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P></BODY></HTML> Fri, 19 Sep 2014 10:24:28 GMT https://community.qlik.com/t5/QlikView/set-analysis-Logic/m-p/647747#M1062633 tresB 2014-09-19T10:24:28Z Re: set analysis Logic https://community.qlik.com/t5/QlikView/set-analysis-Logic/m-p/647748#M1062634 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this. Hope it works...</P><P></P><P>sum ({$&lt;Date&lt;={'2014-01-31'}&gt;} amount)</P></BODY></HTML> Fri, 19 Sep 2014 10:26:23 GMT https://community.qlik.com/t5/QlikView/set-analysis-Logic/m-p/647748#M1062634 2014-09-19T10:26:23Z Re: set analysis Logic https://community.qlik.com/t5/QlikView/set-analysis-Logic/m-p/647749#M1062635 <HTML><HEAD></HEAD><BODY><P>Sum( {&lt; Date = { "=2014-01-31"&gt; amount) ..</P><P></P><P>Hope this helps</P></BODY></HTML> Fri, 19 Sep 2014 11:33:55 GMT https://community.qlik.com/t5/QlikView/set-analysis-Logic/m-p/647749#M1062635 ychaitanya 2014-09-19T11:33:55Z