topic previous month sales in QlikView https://community.qlik.com/t5/QlikView/previous-month-sales/m-p/1028205#M923178 <HTML><HEAD></HEAD><BODY><P>this is current month MTD but i want last month sales not last month MTD</P><P></P><P>(((sum({&lt;SalesFy=,Quarter=,Month=,Week=,BILLDATE=,DateNum={"&gt;=$(=Num(MonthStart(Max(DateNum))))&lt;=$(=num(MonthEnd(max(DateNum))))"}&gt;}BILLDETAILAMOUNT)</P><P>-</P><P>SUM({&lt;SalesFy=,Quarter=,Month=,Week=,BILLDATE=,DateNum={"&gt;=$(=Num(MonthStart(Max(DateNum))))&lt;=$(=num(=MonthEnd(max(DateNum))))"}&gt;}BILLDISCOUNT))</P><P>-</P><P>(sum({&lt;SalesFy=,Quarter=,Month=,Week=,BILLDATE=,DateNum={"&gt;=$(=Num(MonthStart(Max(DateNum))))&lt;=$(=num(=MonthEnd(max(DateNum))))"}&gt;}BILLDETAILAMOUNT))</P><P>-</P><P>(sum({&lt;SalesFy=,Quarter=,Month=,Week=,BILLDATE=,DateNum={"&gt;=$(=Num(MonthStart(Max(DateNum))))&lt;=$(=num(=MonthEnd(max(DateNum))))"}&gt;}BILLDETAILAMOUNT))</P><P>+</P><P>SUM({&lt;SalesFy=,Quarter=,Month=,Week=,BILLDATE=,DateNum={"&gt;=$(=Num(MonthStart(Max(DateNum))))&lt;=$(=num(=MonthEnd(max(DateNum))))"}&gt;}BILLDETAILOTHERSTONECHARGE)</P><P>-</P><P>SUM({&lt;SalesFy=,Quarter=,Month=,Week=,BILLDATE=,DateNum={"&gt;=$(=Num(MonthStart(Max(DateNum))))&lt;=$(=num(=MonthEnd(max(DateNum))))"}&gt;}BILLDETAILOTHERSTONECHARGE)</P><P>-</P><P>SUM({&lt;SalesFy=,Quarter=,Month=,Week=,BILLDATE=,DateNum={"&gt;=$(=Num(MonthStart(Max(DateNum))))&lt;=$(=num(=MonthEnd(max(DateNum))))"}&gt;}BILLDETAILOTHERSTONECHARGE))</P><P>)/(AmtFlag)</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z previous month sales https://community.qlik.com/t5/QlikView/previous-month-sales/m-p/1028205#M923178 <HTML><HEAD></HEAD><BODY><P>this is current month MTD but i want last month sales not last month MTD</P><P></P><P>(((sum({&lt;SalesFy=,Quarter=,Month=,Week=,BILLDATE=,DateNum={"&gt;=$(=Num(MonthStart(Max(DateNum))))&lt;=$(=num(MonthEnd(max(DateNum))))"}&gt;}BILLDETAILAMOUNT)</P><P>-</P><P>SUM({&lt;SalesFy=,Quarter=,Month=,Week=,BILLDATE=,DateNum={"&gt;=$(=Num(MonthStart(Max(DateNum))))&lt;=$(=num(=MonthEnd(max(DateNum))))"}&gt;}BILLDISCOUNT))</P><P>-</P><P>(sum({&lt;SalesFy=,Quarter=,Month=,Week=,BILLDATE=,DateNum={"&gt;=$(=Num(MonthStart(Max(DateNum))))&lt;=$(=num(=MonthEnd(max(DateNum))))"}&gt;}BILLDETAILAMOUNT))</P><P>-</P><P>(sum({&lt;SalesFy=,Quarter=,Month=,Week=,BILLDATE=,DateNum={"&gt;=$(=Num(MonthStart(Max(DateNum))))&lt;=$(=num(=MonthEnd(max(DateNum))))"}&gt;}BILLDETAILAMOUNT))</P><P>+</P><P>SUM({&lt;SalesFy=,Quarter=,Month=,Week=,BILLDATE=,DateNum={"&gt;=$(=Num(MonthStart(Max(DateNum))))&lt;=$(=num(=MonthEnd(max(DateNum))))"}&gt;}BILLDETAILOTHERSTONECHARGE)</P><P>-</P><P>SUM({&lt;SalesFy=,Quarter=,Month=,Week=,BILLDATE=,DateNum={"&gt;=$(=Num(MonthStart(Max(DateNum))))&lt;=$(=num(=MonthEnd(max(DateNum))))"}&gt;}BILLDETAILOTHERSTONECHARGE)</P><P>-</P><P>SUM({&lt;SalesFy=,Quarter=,Month=,Week=,BILLDATE=,DateNum={"&gt;=$(=Num(MonthStart(Max(DateNum))))&lt;=$(=num(=MonthEnd(max(DateNum))))"}&gt;}BILLDETAILOTHERSTONECHARGE))</P><P>)/(AmtFlag)</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/previous-month-sales/m-p/1028205#M923178 2020-11-25T16:16:04Z