QlikView Document - Run Rate Tutorial

    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:

     

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

     

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

    Run Rate Four Examples - QlikView.png

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

     

    Steve

    http://www.quickintelligence.co.uk/qlikview-blog/