Qlik Sense Document - Run Rate Tutorial

stevedark — Thu, 13 Apr 2023 15:51:12 GMT

When showing data in a month on month style the current month can often have a large drop off. This can be prevented by providing a run rate for the current month. This is where the known values for the current period are extrapolated forward for the rest of the period, providing an estimate of where the period will end. For example, if you have a value of 1000 on day 10 of a 30 day month, you could calculate a run rate of 3000 for the month.

This solution was created in response to a question on Qlik Community, which you can find here:

Re: Last time value in time line chart

I have documented how this document works and the reasons why you might use it in a blog post here:

https://www.quickintelligence.co.uk/qlik-run-rate/

There is also a link to the QlikView version of this application on the blog post, and further discussions on why run rates are good to have.

I hope that you find it useful. You will find other applications that I have uploaded under my profile on QlikCommunity.

Steve

https://www.quickintelligence.co.uk/blog/

Re: Qlik Sense Document - Run Rate Tutorial

writetoprithvi — Thu, 18 Jun 2020 03:32:30 GMT

another good example. Thanks for all these example files. they are really helpful

article Qlik Sense Document - Run Rate Tutorial in Member Articles

Qlik Sense Document - Run Rate Tutorial

Re: Qlik Sense Document - Run Rate Tutorial