topic Re: last 12 months data in QlikView https://community.qlik.com/t5/QlikView/last-12-months-data/m-p/369129#M1172426 <HTML><HEAD></HEAD><BODY><P>Try like: </P><P></P><P>=<SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(monthname</SPAN><SPAN style="font-size: 8pt;">&gt;=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">( (</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">MonthStart</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Today</SPAN><SPAN style="font-size: 8pt;">())-365),'MMMYYYY'),<SPAN style="color: #800000;">consumption</SPAN></SPAN><SPAN style="font-size: 8pt;">)) </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Regards</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">R</SPAN></P></BODY></HTML> Thu, 26 Jul 2012 12:03:18 GMT 2012-07-26T12:03:18Z last 12 months data https://community.qlik.com/t5/QlikView/last-12-months-data/m-p/369128#M1172425 <HTML><HEAD></HEAD><BODY><P>i have two column monthname and consumption value</P><P></P><P>monthname has the value between aug2010 to jul2012 and also have consumption repectively</P><P></P><P>now tell me how to calculate consumtion value for the last 12 months</P></BODY></HTML> Thu, 26 Jul 2012 11:01:05 GMT https://community.qlik.com/t5/QlikView/last-12-months-data/m-p/369128#M1172425 2012-07-26T11:01:05Z Re: last 12 months data https://community.qlik.com/t5/QlikView/last-12-months-data/m-p/369129#M1172426 <HTML><HEAD></HEAD><BODY><P>Try like: </P><P></P><P>=<SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(monthname</SPAN><SPAN style="font-size: 8pt;">&gt;=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">( (</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">MonthStart</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Today</SPAN><SPAN style="font-size: 8pt;">())-365),'MMMYYYY'),<SPAN style="color: #800000;">consumption</SPAN></SPAN><SPAN style="font-size: 8pt;">)) </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Regards</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">R</SPAN></P></BODY></HTML> Thu, 26 Jul 2012 12:03:18 GMT https://community.qlik.com/t5/QlikView/last-12-months-data/m-p/369129#M1172426 2012-07-26T12:03:18Z