topic Previous Month in QlikView https://community.qlik.com/t5/QlikView/Previous-Month/m-p/1304498#M824815 <HTML><HEAD></HEAD><BODY><P>Hi All ,</P><P>How do i include this expression in previous month set anakysis ?</P><P></P><P>RangeSum(Above(TOTAL Sum(open) - sum(Close), 0, NoOfRows(TOTAL)))...</P><P></P><P>iam trying to include in this way is this correct ..as shown below</P><P></P><P>=RangeSum(Above(TOTAL Sum(Open) - sum(Close), 0, NoOfRows(TOTAL)),month(addmonths(max(Date), - 1)) )</P><P></P><P></P><P>Thanks in advance....</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT smilingjohn 2020-11-25T16:16:04Z Previous Month https://community.qlik.com/t5/QlikView/Previous-Month/m-p/1304498#M824815 <HTML><HEAD></HEAD><BODY><P>Hi All ,</P><P>How do i include this expression in previous month set anakysis ?</P><P></P><P>RangeSum(Above(TOTAL Sum(open) - sum(Close), 0, NoOfRows(TOTAL)))...</P><P></P><P>iam trying to include in this way is this correct ..as shown below</P><P></P><P>=RangeSum(Above(TOTAL Sum(Open) - sum(Close), 0, NoOfRows(TOTAL)),month(addmonths(max(Date), - 1)) )</P><P></P><P></P><P>Thanks in advance....</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Previous-Month/m-p/1304498#M824815 smilingjohn 2020-11-25T16:16:04Z Re: Previous Month https://community.qlik.com/t5/QlikView/Previous-Month/m-p/1304499#M824817 <HTML><HEAD></HEAD><BODY><P>That isn't a set analysis format. Have you looked at any guides like this <A href="https://community.qlik.com/docs/DOC-4951">Set Analysis: syntaxes, examples</A></P></BODY></HTML> Thu, 13 Jul 2017 14:48:52 GMT https://community.qlik.com/t5/QlikView/Previous-Month/m-p/1304499#M824817 olivetwist 2017-07-13T14:48:52Z