Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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..
Hi,
You can use this expression.
rangesum(above( sum( field name ), 12 ))
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..
Aaron,
The solution you provided worked perfectly. Thanks so much for your help!