How do I make a Run Rate

[CBoardy]

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

[vinieme12]

=avg( YTD Sales)

[Chanty4u]

Try this

RangeSum(Above(Sum({<Month={"<=$(=Max(Month))"}>} [Actual Sales]),0,RowNo())) / RowNo(TOTAL)

[stevedark]

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