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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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

Labels (1)
0 Replies