Discussion board where members can get started with Qlik Sense.
Hoping you could help me.
I want to avg(sales) for the current month 12 months ago so July 2017
I already have a current month flag field which returns 1 or 0, (today's month- July 2018.)
I want to get the avg(sales) for the current month, 12 months ago.
I have already tried this but its not working:
Could i please request to try do this in the front end if possible
How is the MonthYear field created? It should be a date, but not just a string value. Otherwise max(MonthYear) won't return a date value that can be calculated with in the addmonths function.
You could check if Num(MonthYear) returns a number.
I have another Date field that I am using called DateKEY. This can be turned into a Number with the NUM()
I am able to get July 2017 with this expression
However i cant get the average of monthly sales in there
What would you propose?