Total Profit by Year

[mphekin12]

Hello,

I'm trying to get a figure out how to create the column 'Total Profit by Year' in QlikView.  Can someone please explain how it can be done?

Thank you!

[#2]

Hi,

You can use this expression.

rangesum(above( sum( field name ), 12 ))

[morganaaron · Accepted solution]

RangeSum(Above(Sum(Profit), 0, Num(Month)))

Assuming your field is called Profit and your Month-Year has been created from a master calendar including Month and Year...alternatively use the Num(Month(MonthYear)) if not..

[mphekin12]

Aaron,

The solution you provided worked perfectly.  Thanks so much for your help!