topic How to sum a single month when it is not the current month? in QlikView

How to sum a single month when it is not the current month?

Anonymous — Thu, 05 Apr 2018 21:01:05 GMT

I want to sum the most current month's Reserve balance data. Right now it is April, but the February data was just populated, so I need just the February data.

I have two fields that I could use for the date: [Reserve Month] which is just the month name, and [Edit Date] which is the numerical MMM-DD-YYYY

The field I want calculated is [Reserve Balance].

Thank you!

Re: How to sum a single month when it is not the current month?

Digvijay_Singh — Thu, 05 Apr 2018 21:14:28 GMT

Something like this may be -

Sum({<[Edit Date] ={">=$(=MonthStart([Edit Date]))"}>}[Reserve Balance])

Re: How to sum a single month when it is not the current month?

Digvijay_Singh — Thu, 05 Apr 2018 21:15:37 GMT

Corrected one -

Sum({<[Edit Date] ={">=$(=MonthStart(Date(Max([Edit Date]))))"}>}[Reserve Balance])