topic Re: Previous MonthYear presentation in QlikView https://community.qlik.com/t5/QlikView/Previous-MonthYear-presentation/m-p/663779#M241762 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Additional information: I have made the variable 'Previous MonthYear': </SPAN><SPAN style="color: #800000; font-size: 8pt;">MonthYear_Period_ID</SPAN><SPAN style="font-size: 8pt;"> -12.</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">The expression of Sales Previous period will be:&nbsp; <SPAN style="color: #0000ff; font-size: 10pt;">sum</SPAN><SPAN style="font-size: 10pt;">({&lt;</SPAN><STRONG><EM style=": ; color: #808080; font-size: 10pt;">$(Previous MonthYear)</EM></STRONG><SPAN style="font-size: 10pt;">&gt;} <SPAN style="color: #808080; font-size: 10pt;"><STRONG><EM>$(vSales)</EM></STRONG></SPAN>) </SPAN></SPAN></P><P><SPAN style="font-size: 10pt;">Now this expression is only working for<SPAN style="text-decoration: underline;"> one </SPAN>selection in filter MonthYear.</SPAN></P><P><SPAN style="font-size: 10pt;">I want to see the selection from Oct 2012 - Mar 2013 when using filter MonthYear for the previous period of Oct 2013-Mar 2014. </SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">Who knows the solution for my issue?</SPAN><SPAN style="font-size: 10pt;"> <BR /></SPAN></P><P><SPAN style="font-size: 10pt;">&nbsp; </SPAN></P><P> </P><P></P><P> </P><P></P></BODY></HTML> Tue, 23 Sep 2014 12:13:53 GMT 2014-09-23T12:13:53Z Previous MonthYear presentation https://community.qlik.com/t5/QlikView/Previous-MonthYear-presentation/m-p/663778#M241761 <HTML><HEAD></HEAD><BODY><P>How do I realize the calculation in my straight table chart expression of column Sales (Previous period) based on filter MonthYear?</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Filter MonthYear</STRONG></TH></TR><TR><TD style="padding: 2px;">Jul 2013&nbsp;&nbsp; Aug 2013&nbsp;&nbsp; Sep 2013&nbsp;&nbsp; Okt 2013&nbsp;&nbsp; Nov 2013&nbsp;&nbsp; Dec 2013&nbsp;&nbsp; Jan 2014&nbsp;&nbsp; Feb 2014&nbsp;&nbsp; Mar 2014&nbsp;&nbsp; Apr 2014&nbsp;&nbsp; May 2014</TD></TR></TBODY></TABLE><P></P><TABLE border="1" class="jiveBorder" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P><STRONG>Sales </STRONG></P><P><STRONG>October 2013 - March 2014</STRONG></P></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P><STRONG>Sales (Previous period) </STRONG></P><P><STRONG>October 2012 - March 2013</STRONG></P></TH></TR><TR><TD style="padding: 2px;">1000</TD><TD style="padding: 2px;">1600</TD></TR><TR><TD style="padding: 2px;">1500</TD><TD style="padding: 2px;">1400</TD></TR><TR><TD style="padding: 2px;">3000</TD><TD style="padding: 2px;">3900</TD></TR><TR><TD style="padding: 2px;">5000</TD><TD style="padding: 2px;">4500</TD></TR></TBODY></TABLE><P></P><P><SPAN style="color: #0000ff; font-size: 10pt;">Expression Sales column (Oct 2013 - Mar 2014):&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #0000ff; font-size: 10pt;">Expression Sales Previous period <BR />&nbsp;&nbsp; <SPAN style="font-size: 10pt;">sum({&lt;</SPAN><SPAN style="color: #800000; font-size: 10pt;">Year</SPAN><SPAN style="font-size: 10pt;">=,</SPAN><SPAN style="color: #800000; font-size: 10pt;">Month</SPAN><SPAN style="font-size: 10pt;">=,</SPAN><SPAN style="color: #800000; font-size: 10pt;">Week</SPAN><SPAN style="font-size: 10pt;">=&gt;}</SPAN><SPAN style="; color: #808080; font-size: 10pt;"><STRONG><EM>_Sales_amount)</EM></STRONG></SPAN><SPAN style="font-size: 10pt;">) </SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (Oct 2012-March 2013):?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN> </SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN><SPAN style="font-size: 10pt;">In script: </SPAN></P><P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">MonthName</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">TempDate</SPAN><SPAN style="font-size: 8pt;">),</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Year</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">TempDate</SPAN><SPAN style="font-size: 8pt;">) &amp; </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">right</SPAN><SPAN style="font-size: 8pt;">(0 &amp; </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">num</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Month</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">TempDate</SPAN><SPAN style="font-size: 8pt;">)),2)) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">MonthYear</SPAN><SPAN style="font-size: 8pt;">, </SPAN></P><P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">TempDate</SPAN><SPAN style="font-size: 8pt;">)*100 + </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">month</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">TempDate</SPAN><SPAN style="font-size: 8pt;">) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">MonthYear_Period</SPAN><SPAN style="font-size: 8pt;">, </SPAN></P><P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">MonthYear_Period</SPAN><SPAN style="font-size: 8pt;">,'MonthYear_Period_ID') </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">MonthYear_Period_ID </SPAN></P></BODY></HTML> Mon, 22 Sep 2014 15:02:11 GMT https://community.qlik.com/t5/QlikView/Previous-MonthYear-presentation/m-p/663778#M241761 2014-09-22T15:02:11Z Re: Previous MonthYear presentation https://community.qlik.com/t5/QlikView/Previous-MonthYear-presentation/m-p/663779#M241762 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Additional information: I have made the variable 'Previous MonthYear': </SPAN><SPAN style="color: #800000; font-size: 8pt;">MonthYear_Period_ID</SPAN><SPAN style="font-size: 8pt;"> -12.</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">The expression of Sales Previous period will be:&nbsp; <SPAN style="color: #0000ff; font-size: 10pt;">sum</SPAN><SPAN style="font-size: 10pt;">({&lt;</SPAN><STRONG><EM style=": ; color: #808080; font-size: 10pt;">$(Previous MonthYear)</EM></STRONG><SPAN style="font-size: 10pt;">&gt;} <SPAN style="color: #808080; font-size: 10pt;"><STRONG><EM>$(vSales)</EM></STRONG></SPAN>) </SPAN></SPAN></P><P><SPAN style="font-size: 10pt;">Now this expression is only working for<SPAN style="text-decoration: underline;"> one </SPAN>selection in filter MonthYear.</SPAN></P><P><SPAN style="font-size: 10pt;">I want to see the selection from Oct 2012 - Mar 2013 when using filter MonthYear for the previous period of Oct 2013-Mar 2014. </SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">Who knows the solution for my issue?</SPAN><SPAN style="font-size: 10pt;"> <BR /></SPAN></P><P><SPAN style="font-size: 10pt;">&nbsp; </SPAN></P><P> </P><P></P><P> </P><P></P></BODY></HTML> Tue, 23 Sep 2014 12:13:53 GMT https://community.qlik.com/t5/QlikView/Previous-MonthYear-presentation/m-p/663779#M241762 2014-09-23T12:13:53Z