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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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