topic Re: Prev Month Issue in QlikView https://community.qlik.com/t5/QlikView/Prev-Month-Issue/m-p/1069642#M357409 <HTML><HEAD></HEAD><BODY><P>Right, sorry, you need to ignore the selection in&nbsp; Month field:</P><P></P><P>Sum({&lt;MonthNum={$(=Max(MonthNum)-1)}<STRONG>, Month=</STRONG> &gt;} Sales)</P></BODY></HTML> Wed, 20 Apr 2016 15:21:14 GMT swuehl 2016-04-20T15:21:14Z Prev Month Issue https://community.qlik.com/t5/QlikView/Prev-Month-Issue/m-p/1069639#M357406 <HTML><HEAD></HEAD><BODY><P>Attached please find the sample data and sample qvw.&nbsp; I need to calculate&nbsp; current month and previous month sales.&nbsp;&nbsp; I am not getting any values&nbsp; if I try to calculate Previous Months Sales.</P><P></P><P>Any ideas what am I doing wrong here</P></BODY></HTML> Wed, 20 Apr 2016 15:00:43 GMT https://community.qlik.com/t5/QlikView/Prev-Month-Issue/m-p/1069639#M357406 2016-04-20T15:00:43Z Re: Prev Month Issue https://community.qlik.com/t5/QlikView/Prev-Month-Issue/m-p/1069640#M357407 <HTML><HEAD></HEAD><BODY><P>Your Month field is a text field, so Max(Month) won't work.</P><P></P><P>See attached for a quick fix, but in more detail, see</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> Wed, 20 Apr 2016 15:11:31 GMT https://community.qlik.com/t5/QlikView/Prev-Month-Issue/m-p/1069640#M357407 swuehl 2016-04-20T15:11:31Z Re: Prev Month Issue https://community.qlik.com/t5/QlikView/Prev-Month-Issue/m-p/1069641#M357408 <HTML><HEAD></HEAD><BODY><P>Your sample still doesnt work, if I select Apr, Prev month column is still 0</P></BODY></HTML> Wed, 20 Apr 2016 15:17:23 GMT https://community.qlik.com/t5/QlikView/Prev-Month-Issue/m-p/1069641#M357408 2016-04-20T15:17:23Z Re: Prev Month Issue https://community.qlik.com/t5/QlikView/Prev-Month-Issue/m-p/1069642#M357409 <HTML><HEAD></HEAD><BODY><P>Right, sorry, you need to ignore the selection in&nbsp; Month field:</P><P></P><P>Sum({&lt;MonthNum={$(=Max(MonthNum)-1)}<STRONG>, Month=</STRONG> &gt;} Sales)</P></BODY></HTML> Wed, 20 Apr 2016 15:21:14 GMT https://community.qlik.com/t5/QlikView/Prev-Month-Issue/m-p/1069642#M357409 swuehl 2016-04-20T15:21:14Z