topic Last month Value in QlikView https://community.qlik.com/t5/QlikView/Last-month-Value/m-p/284160#M580304 <HTML><HEAD></HEAD><BODY><P> Hi all, I can´t get the last month value, could you help me? </P><P></P><P>I attached the app.</P><P></P><P>Thanks!!</P></BODY></HTML> Tue, 17 Jan 2012 22:39:37 GMT 2012-01-17T22:39:37Z Last month Value https://community.qlik.com/t5/QlikView/Last-month-Value/m-p/284160#M580304 <HTML><HEAD></HEAD><BODY><P> Hi all, I can´t get the last month value, could you help me? </P><P></P><P>I attached the app.</P><P></P><P>Thanks!!</P></BODY></HTML> Tue, 17 Jan 2012 22:39:37 GMT https://community.qlik.com/t5/QlikView/Last-month-Value/m-p/284160#M580304 2012-01-17T22:39:37Z Last month Value https://community.qlik.com/t5/QlikView/Last-month-Value/m-p/284161#M580305 <HTML><HEAD></HEAD><BODY><P> I solved it!!</P><P></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><SPAN style="color: #0000ff; font-size: 8pt;"></SPAN></SPAN></P><P>sum</P><P></P><P></P><P><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Mes</SPAN><SPAN style="font-size: 8pt;"> = {</SPAN><STRONG><EM style=": ; color: #808080; font-size: 8pt;">$(=month(addmonths(max([Mes-Año]), -1)))</EM></STRONG><EM style=": ; color: #808080; font-size: 8pt;"> </EM><SPAN style="color: #808080; font-size: 8pt;"> </SPAN><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Valor Surcharge Nuevo]</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P><SPAN style="font-size: 8pt;"> </SPAN></P></BODY></HTML> Tue, 17 Jan 2012 23:06:11 GMT https://community.qlik.com/t5/QlikView/Last-month-Value/m-p/284161#M580305 2012-01-17T23:06:11Z