topic MTD Expression suddenly not working in QlikView https://community.qlik.com/t5/QlikView/MTD-Expression-suddenly-not-working/m-p/332520#M122526 <HTML><HEAD></HEAD><BODY><P> Hi Michael... Thanks for pointing it out. You were right. The feed to my application broke and I had no data for the Month of May. I kept on thinking April and testing that data.</P><P></P><P>Appreciate your help!!</P></BODY></HTML> Wed, 02 May 2012 19:23:07 GMT 2012-05-02T19:23:07Z MTD Expression suddenly not working https://community.qlik.com/t5/QlikView/MTD-Expression-suddenly-not-working/m-p/332516#M122522 <HTML><HEAD></HEAD><BODY><P>I had this MTD expression working for almost a month and suddenly something went wrong and I am unable to figure it out. May be it is something small that I might be missing here. </P><P></P><P>This is the expression </P><P>Sum({&lt;[Year] = {$(=Year(Today()))},[Month]={$(=Month(Today()))}&gt;}Sales) </P><P><SPAN style="color: #0000ff; font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;"> </SPAN></P><P></P><P></P><P></P><P></P><P></P><P><SPAN style="color: #000000; font-size: 10pt;"><SPAN style="color: #0000ff; font-size: 8pt;"></SPAN>It Calculates MTD sales</SPAN></P><P><SPAN style="color: #000000; font-size: 10pt;"></SPAN></P><P><SPAN style="font-size: 10pt;"><SPAN style="color: #000000;"><SPAN style="color: #0000ff; font-size: 8pt;"></SPAN>Any suggestion will be helpful. Thanks<A></A></SPAN><A></A><A></A><A></A><A></A><A></A></SPAN><A></A><A></A></P></BODY></HTML> Wed, 02 May 2012 14:49:56 GMT https://community.qlik.com/t5/QlikView/MTD-Expression-suddenly-not-working/m-p/332516#M122522 2012-05-02T14:49:56Z MTD Expression suddenly not working https://community.qlik.com/t5/QlikView/MTD-Expression-suddenly-not-working/m-p/332517#M122523 <HTML><HEAD></HEAD><BODY><P>use below code hope this helps</P><P></P><P><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">Sum({&lt;[Year] = {$(=Year(Today()))},[Month]={"&lt;=$(=Month(Today()))"}&gt;}Sales)</SPAN></P></BODY></HTML> Wed, 02 May 2012 15:15:46 GMT https://community.qlik.com/t5/QlikView/MTD-Expression-suddenly-not-working/m-p/332517#M122523 SunilChauhan 2012-05-02T15:15:46Z MTD Expression suddenly not working https://community.qlik.com/t5/QlikView/MTD-Expression-suddenly-not-working/m-p/332518#M122524 <HTML><HEAD></HEAD><BODY><P> Sunil This is not working..<IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Wed, 02 May 2012 17:51:12 GMT https://community.qlik.com/t5/QlikView/MTD-Expression-suddenly-not-working/m-p/332518#M122524 2012-05-02T17:51:12Z MTD Expression suddenly not working https://community.qlik.com/t5/QlikView/MTD-Expression-suddenly-not-working/m-p/332519#M122525 <HTML><HEAD></HEAD><BODY><P> Logic looks fine.&nbsp; Check the format of the data, make sure that Month(today()) has the same format as field Month.<BR />Or, maybe there are Sales data yet in the current month?&nbsp; It just started...</P></BODY></HTML> Wed, 02 May 2012 18:48:34 GMT https://community.qlik.com/t5/QlikView/MTD-Expression-suddenly-not-working/m-p/332519#M122525 Anonymous 2012-05-02T18:48:34Z MTD Expression suddenly not working https://community.qlik.com/t5/QlikView/MTD-Expression-suddenly-not-working/m-p/332520#M122526 <HTML><HEAD></HEAD><BODY><P> Hi Michael... Thanks for pointing it out. You were right. The feed to my application broke and I had no data for the Month of May. I kept on thinking April and testing that data.</P><P></P><P>Appreciate your help!!</P></BODY></HTML> Wed, 02 May 2012 19:23:07 GMT https://community.qlik.com/t5/QlikView/MTD-Expression-suddenly-not-working/m-p/332520#M122526 2012-05-02T19:23:07Z