Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!

QlikView Document - Run Rate Tutorial

cancel
Showing results for 
Search instead for 
Did you mean: 
stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

QlikView Document - Run Rate Tutorial

Last Update:

Sep 20, 2022 1:53:53 PM

Updated By:

Sue_Macaluso

Created date:

Jul 1, 2015 6:55:10 PM

Attachments

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/

Version history
Last update:
‎2022-09-20 01:53 PM
Updated by: