topic Re: Unable to get values using Month in QlikView https://community.qlik.com/t5/QlikView/Unable-to-get-values-using-Month/m-p/733620#M262830 <HTML><HEAD></HEAD><BODY><P>=Sum({$&lt;<STRONG>M=</STRONG>,Month={"&lt;=$(=MonthEnd(AddMonths(Max(Month),-1)))"}&gt;}Amount)</P></BODY></HTML> Thu, 18 Sep 2014 17:59:41 GMT maxgro 2014-09-18T17:59:41Z Unable to get values using Month https://community.qlik.com/t5/QlikView/Unable-to-get-values-using-Month/m-p/733616#M262826 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; i m using Below expression:</P><P>&nbsp;&nbsp;&nbsp; =Sum({$&lt;Date = {"&lt;=$(=MonthEnd(AddMonths(Max(Date),-1)))"}&gt;}Amount)</P><P></P><P>It is Working fine .when i select on Date field it is fine .</P><P>Date field contains 21/1/2013 format </P><P>If i use Month(Date) and i select on particular month&nbsp; it is giving output as 0.</P><P></P><P>Pls suggest me.</P><P></P><P>Thanks in Advance</P><P></P><P>Regards,</P><P>Divya</P></BODY></HTML> Thu, 18 Sep 2014 14:18:07 GMT https://community.qlik.com/t5/QlikView/Unable-to-get-values-using-Month/m-p/733616#M262826 2014-09-18T14:18:07Z Re: Unable to get values using Month https://community.qlik.com/t5/QlikView/Unable-to-get-values-using-Month/m-p/733617#M262827 <HTML><HEAD></HEAD><BODY><P>this might help</P></BODY></HTML> Thu, 18 Sep 2014 14:20:40 GMT https://community.qlik.com/t5/QlikView/Unable-to-get-values-using-Month/m-p/733617#M262827 giakoum 2014-09-18T14:20:40Z Re: Unable to get values using Month https://community.qlik.com/t5/QlikView/Unable-to-get-values-using-Month/m-p/733618#M262828 <HTML><HEAD></HEAD><BODY><P>What is the result of expr - <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><STRONG>MonthEnd(AddMonths(Max(Date),-1)) ? </STRONG>Is this result in date format?</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Can you add sample qvw<BR /></SPAN></P></BODY></HTML> Thu, 18 Sep 2014 14:21:25 GMT https://community.qlik.com/t5/QlikView/Unable-to-get-values-using-Month/m-p/733618#M262828 anbu1984 2014-09-18T14:21:25Z Re: Unable to get values using Month https://community.qlik.com/t5/QlikView/Unable-to-get-values-using-Month/m-p/733619#M262829 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>PFA,</P><P></P><P>Thanks in Advance</P></BODY></HTML> Thu, 18 Sep 2014 17:39:25 GMT https://community.qlik.com/t5/QlikView/Unable-to-get-values-using-Month/m-p/733619#M262829 2014-09-18T17:39:25Z Re: Unable to get values using Month https://community.qlik.com/t5/QlikView/Unable-to-get-values-using-Month/m-p/733620#M262830 <HTML><HEAD></HEAD><BODY><P>=Sum({$&lt;<STRONG>M=</STRONG>,Month={"&lt;=$(=MonthEnd(AddMonths(Max(Month),-1)))"}&gt;}Amount)</P></BODY></HTML> Thu, 18 Sep 2014 17:59:41 GMT https://community.qlik.com/t5/QlikView/Unable-to-get-values-using-Month/m-p/733620#M262830 maxgro 2014-09-18T17:59:41Z