Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

previous month sales

this is current month MTD but i want last month sales not last month MTD

(((sum({<SalesFy=,Quarter=,Month=,Week=,BILLDATE=,DateNum={">=$(=Num(MonthStart(Max(DateNum))))<=$(=num(MonthEnd(max(DateNum))))"}>}BILLDETAILAMOUNT)

-

SUM({<SalesFy=,Quarter=,Month=,Week=,BILLDATE=,DateNum={">=$(=Num(MonthStart(Max(DateNum))))<=$(=num(=MonthEnd(max(DateNum))))"}>}BILLDISCOUNT))

-

(sum({<SalesFy=,Quarter=,Month=,Week=,BILLDATE=,DateNum={">=$(=Num(MonthStart(Max(DateNum))))<=$(=num(=MonthEnd(max(DateNum))))"}>}BILLDETAILAMOUNT))

-

(sum({<SalesFy=,Quarter=,Month=,Week=,BILLDATE=,DateNum={">=$(=Num(MonthStart(Max(DateNum))))<=$(=num(=MonthEnd(max(DateNum))))"}>}BILLDETAILAMOUNT))

+

SUM({<SalesFy=,Quarter=,Month=,Week=,BILLDATE=,DateNum={">=$(=Num(MonthStart(Max(DateNum))))<=$(=num(=MonthEnd(max(DateNum))))"}>}BILLDETAILOTHERSTONECHARGE)

-

SUM({<SalesFy=,Quarter=,Month=,Week=,BILLDATE=,DateNum={">=$(=Num(MonthStart(Max(DateNum))))<=$(=num(=MonthEnd(max(DateNum))))"}>}BILLDETAILOTHERSTONECHARGE)

-

SUM({<SalesFy=,Quarter=,Month=,Week=,BILLDATE=,DateNum={">=$(=Num(MonthStart(Max(DateNum))))<=$(=num(=MonthEnd(max(DateNum))))"}>}BILLDETAILOTHERSTONECHARGE))

)/(AmtFlag)

Labels (1)
0 Replies