Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have a graph that cotains YTD Actual Sales, FY Target Sales. I would like to create a line in the graph that is a run rate and would update every load.
For Example:
Jan- $2.8m , Feb- $3.17m , Mar- $2.96m
The run rate line would show the Actual sales for passed months and then for remaining months it shows the average of actuals.
Many Thanks
=avg( YTD Sales)
Try this
RangeSum(Above(Sum({<Month={"<=$(=Max(Month))"}>} [Actual Sales]),0,RowNo())) / RowNo(TOTAL)
Hi @CBoardy
You might want to take a look at this blog post on the topic:
https://www.quickintelligence.co.uk/qlik-run-rate/
There is a link to an example document you can download and use at the bottom of the article.
Hope that helps.
Steve