Need Previous Month Details using this query...

Wed, 27 Apr 2016 07:13:42 GMT

Hi Guys,

i been asked by get previous month of details using this query , help me out...

(((sum({<SalesFy=,Quarter=,Month=,Week=,BILLDATE=,DateNum={">=$(=Num(MonthStart(Max(DateNum),-1)))<=$(=num(MonthEnd(max(DateNum))))"},BILLDETAILENTRYTYPE = {'B'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}>}BILLDETAILAMOUNT)

SUM({<SalesFy=,Quarter=,Month=,Week=,BILLDATE=,DateNum={">=$(=Num(MonthStart(Max(DateNum),-1)))<=$(=num(=MonthEnd(max(DateNum))))"},BILLDETAILENTRYTYPE = {'B'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}>}BILLDISCOUNT))

(sum({<SalesFy=,Quarter=,Month=,Week=,BILLDATE=,DateNum={">=$(=Num(MonthStart(Max(DateNum),-1)))<=$(=num(=MonthEnd(max(DateNum))))"},BILLDETAILENTRYTYPE = {'R'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}>}BILLDETAILAMOUNT))

(sum({<SalesFy=,Quarter=,Month=,Week=,BILLDATE=,DateNum={">=$(=Num(MonthStart(Max(DateNum),-1)))<=$(=num(=MonthEnd(max(DateNum))))"}, BILLDETAILENTRYTYPE = {'O'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'},URDPURCHASE = {'Y'}>}BILLDETAILAMOUNT))

SUM({<SalesFy=,Quarter=,Month=,Week=,BILLDATE=,DateNum={">=$(=Num(MonthStart(Max(DateNum),-1)))<=$(=num(=MonthEnd(max(DateNum))))"},BILLDETAILENTRYTYPE = {'R'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}>}BILLDETAILOTHERSTONECHARGE)

SUM({<SalesFy=,Quarter=,Month=,Week=,BILLDATE=,DateNum={">=$(=Num(MonthStart(Max(DateNum),-1)))<=$(=num(=MonthEnd(max(DateNum))))"},BILLDETAILENTRYTYPE = {'O'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'},URDPURCHASE = {'Y'}>}BILLDETAILOTHERSTONECHARGE))

)/(AmtFlag)

Thanks in advance

Re: Need Previous Month Details using this query...

sunny_talwar — Wed, 27 Apr 2016 15:55:21 GMT

What is this query calculating right now? Current Month?

Re: Need Previous Month Details using this query...

Thu, 28 Apr 2016 04:21:49 GMT

Yeah Sunny it evaluates current month but, this question been solved...

Thanx for your concern....

Re: Need Previous Month Details using this query...

sasikanth — Thu, 28 Apr 2016 04:36:51 GMT

HI,

i think your current query is calculating both current and previous months related data

">=$(=Num(MonthStart(Max(DateNum),-1))) --> Previous Month start

<=$(=num(=MonthEnd(max(DateNum))))" --> current Month end

if you need to calculate only previous month related data then use this

">=$(=Num(MonthStart(Max(DateNum),-1))) <=$(=num(=MonthEnd(max(DateNum),-1)))"

topic Re: Need Previous Month Details using this query... in QlikView

Need Previous Month Details using this query...

Re: Need Previous Month Details using this query...

Re: Need Previous Month Details using this query...

Re: Need Previous Month Details using this query...