Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

0 Replies