Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
CBoardy
Contributor III
Contributor III

How do I make a Run Rate

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

Labels (4)
3 Replies
vinieme12
Champion III
Champion III

=avg( YTD Sales)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Chanty4u
MVP
MVP

Try this

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

 

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

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