topic Re: Previous Month value in QlikView https://community.qlik.com/t5/QlikView/Previous-Month-value/m-p/1303128#M405886 <HTML><HEAD></HEAD><BODY><P>Have a look at</P><P><A href="http://aftersync.com/blog/the-magic-of-set-analysis-point-in-time-reporting" title="http://aftersync.com/blog/the-magic-of-set-analysis-point-in-time-reporting">The Magic of Set Analysis - Point In Time Reporting • Blog • AfterSync</A></P></BODY></HTML> Sun, 23 Apr 2017 18:59:06 GMT swuehl 2017-04-23T18:59:06Z Previous Month value https://community.qlik.com/t5/QlikView/Previous-Month-value/m-p/1303127#M405885 <HTML><HEAD></HEAD><BODY><P>Hi all, </P><P></P><P>I want to find previous month value </P><P></P><P>example </P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="192"><TBODY><TR><TD height="20" width="64">Year </TD><TD width="64">Month </TD><TD width="64">Sales</TD></TR><TR><TD align="right" height="20">2016</TD><TD>Jan </TD><TD align="right">100</TD></TR><TR><TD align="right" height="20">2016</TD><TD>Feb</TD><TD align="right">200</TD></TR><TR><TD align="right" height="20">2016</TD><TD>Mar</TD><TD align="right">300</TD></TR><TR><TD align="right" height="20">2016</TD><TD>Apr</TD><TD align="right">400</TD></TR><TR><TD align="right" height="20">2016</TD><TD>May</TD><TD align="right">500</TD></TR><TR><TD align="right" height="20">2016</TD><TD>Jun</TD><TD align="right">600</TD></TR><TR><TD align="right" height="20">2016</TD><TD>Jul</TD><TD align="right">700</TD></TR><TR><TD align="right" height="20">2016</TD><TD>Aug</TD><TD align="right">800</TD></TR><TR><TD align="right" height="20">2016</TD><TD>Sep</TD><TD align="right">900</TD></TR><TR><TD align="right" height="20">2016</TD><TD>Oct</TD><TD align="right">1000</TD></TR><TR><TD align="right" height="20">2016</TD><TD>Nov</TD><TD align="right">1100</TD></TR><TR><TD align="right" height="20">2016</TD><TD>Dec</TD><TD align="right">1200</TD></TR><TR><TD align="right" height="20">2017</TD><TD>Jan </TD><TD align="right">1300</TD></TR><TR><TD align="right" height="20">2017</TD><TD>Feb</TD><TD align="right">1400</TD></TR><TR><TD align="right" height="20">2017</TD><TD>Mar</TD><TD align="right">1500</TD></TR></TBODY></TABLE><P></P><P>1) Currently it should show value for Feb 2017</P><P>2) If i select Jan 2017 it should show Dec 2016 value</P><P></P><P>thanks in advance</P><P></P><P></P><P></P><P>.</P></BODY></HTML> Sun, 23 Apr 2017 18:52:37 GMT https://community.qlik.com/t5/QlikView/Previous-Month-value/m-p/1303127#M405885 Anonymous 2017-04-23T18:52:37Z Re: Previous Month value https://community.qlik.com/t5/QlikView/Previous-Month-value/m-p/1303128#M405886 <HTML><HEAD></HEAD><BODY><P>Have a look at</P><P><A href="http://aftersync.com/blog/the-magic-of-set-analysis-point-in-time-reporting" title="http://aftersync.com/blog/the-magic-of-set-analysis-point-in-time-reporting">The Magic of Set Analysis - Point In Time Reporting • Blog • AfterSync</A></P></BODY></HTML> Sun, 23 Apr 2017 18:59:06 GMT https://community.qlik.com/t5/QlikView/Previous-Month-value/m-p/1303128#M405886 swuehl 2017-04-23T18:59:06Z