topic Re: Prior month by selected month in QlikView https://community.qlik.com/t5/QlikView/Prior-month-by-selected-month/m-p/668878#M474733 <HTML><HEAD></HEAD><BODY><P>where you want to get the previous month?</P><P>can you explain mor eindetail within your application?</P><P></P><P>you can use addmonths for instance</P><P>addmonths(date,-1) will get you the previous month</P></BODY></HTML> Thu, 28 Aug 2014 09:01:25 GMT Anonymous 2014-08-28T09:01:25Z Prior month by selected month https://community.qlik.com/t5/QlikView/Prior-month-by-selected-month/m-p/668877#M474732 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>How i can get prior month from by selected month ?</P><P>For example, if i choose october, i need to get september</P><P>Thank you!</P><P></P><P>There is attached model</P></BODY></HTML> Thu, 28 Aug 2014 08:55:16 GMT https://community.qlik.com/t5/QlikView/Prior-month-by-selected-month/m-p/668877#M474732 Anonymous 2014-08-28T08:55:16Z Re: Prior month by selected month https://community.qlik.com/t5/QlikView/Prior-month-by-selected-month/m-p/668878#M474733 <HTML><HEAD></HEAD><BODY><P>where you want to get the previous month?</P><P>can you explain mor eindetail within your application?</P><P></P><P>you can use addmonths for instance</P><P>addmonths(date,-1) will get you the previous month</P></BODY></HTML> Thu, 28 Aug 2014 09:01:25 GMT https://community.qlik.com/t5/QlikView/Prior-month-by-selected-month/m-p/668878#M474733 Anonymous 2014-08-28T09:01:25Z Re: Prior month by selected month https://community.qlik.com/t5/QlikView/Prior-month-by-selected-month/m-p/668879#M474734 <HTML><HEAD></HEAD><BODY><P>Try:</P><P>=Sum({&lt;Month={"$(=Month(AddMonths(Max(Date),-1)))"}&gt;}Quantity)</P></BODY></HTML> Thu, 28 Aug 2014 09:03:28 GMT https://community.qlik.com/t5/QlikView/Prior-month-by-selected-month/m-p/668879#M474734 tresB 2014-08-28T09:03:28Z Re: Prior month by selected month https://community.qlik.com/t5/QlikView/Prior-month-by-selected-month/m-p/668880#M474735 <HTML><HEAD></HEAD><BODY><P>Perfect!</P><P>Thank you.</P></BODY></HTML> Thu, 28 Aug 2014 09:07:56 GMT https://community.qlik.com/t5/QlikView/Prior-month-by-selected-month/m-p/668880#M474735 Anonymous 2014-08-28T09:07:56Z