Qlik Community

Ask a Question

QlikView Documents

QlikView documentation and resources.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY

Qlik Sense Document - Run Rate Tutorial

stevedark
Luminary Alumni
Luminary Alumni

Qlik Sense 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 QlikView version of this application on the blog post, and further discussions on why run rates are good to have.

Run Rate Four Examples.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/

Attachments
Comments
writetoprithvi
Contributor II
Contributor II

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

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2015-07-01 06:45 PM
Updated by: