Need some help with code, currently year to date want single month

Mon, 28 Nov 2011 10:42:41 GMT

Hi!

In one of my reports the result for last year actuals ends up as year to date (accumulated) figures when I select a single month. I need some help adjusting the code so it is possible to select a single months value.

sum({$<Month={"*"}, Year={"*"}, [Year Quarter]={"*"}, YearCounter={"$(#=max(YearCounter-1))"}, RRResultatPost = {'NetSales'}>}Amount_$(vCurr))//Sum({<RRResultatPost= {'Net Sales'}>} Amount)//=sum({$<Month={"*"},Year={"*"}, [Year Quarter]={"*"},YearCounter={"$(#=max(YearCounter-1))"}>}Amount)
//Sum({<RRResultatPost = {'Net Sales'}>} Amount)

Hope someone can help me

Regards / Fredrik

topic Need some help with code, currently year to date want single month in QlikView

Need some help with code, currently year to date want single month