Now you can create predictions and forecasts in Qlik Sense without a single line of code or being a data scientist using the WoW Predictive Line Chart!

It can be used for making predictions on Qlik measure or expression.  The best part it is free with no user limits. Create dynamic seasonal, linear, exponential predictions in seconds. Great for when you need to visualise a best case, normal case and worst case scenario analysis on your data.

Create forecasts and predictions in Qlik Sense

Extension Setup

The WebOfWork Predictive Line Chart Extension is a downloadable extension that you import just like any other extension in Qlik Sense. Import it via the extension manager in the QMC on Qlik Sense Server or unzip into your extension folder in Qlik Sense Desktop.

How To Use

Step 1 - Download and drop the extension into your Qlik Sense app.

Navigate to the About section, login using your WebOfWork username and password to verify the extension if it is not already verified. Don't worry it is free!

Step 2 - Configure the extension

The extension works pretty much out the box.

  1. Dimension - Choose a Time or Numeric field
  2. Measure - The expression you want to do a forward prediction on.

Prediction Types

The WoW Predictive Line Chart supports a number of prediction types.

Seasonal (ARIMA method)

Settings:

  • Forward Periods (Required) - The number of periods to make the prediction over for the line.
  • Training Periods (Required) - The number of periods to calculate seasonal variation over.
  • Line Color  (Required)
  • Percentage Modifier (Optional) - This lets you modify the estimate with a %. Great for creating worst and best case lines!

Linear

Settings:

  • Forward Periods (Required) - The number of periods to make the prediction over for the line.
  • Line Color  (Required)
  • Percentage Modifier (Optional) - This lets you modify the estimate with a %. Great for creating worst and best case lines!

Polynomial

Settings:

  • Forward Periods (Required) - The number of periods to make the prediction over for the line.
  • Line Color  (Required)
  • Percentage Modifier (Optional) - This lets you modify the estimate with a %. Great for creating worst and best case lines!

Percentage Change

Settings:

  • Forward Periods - The number of periods to make the prediction over for the line.

Exponential

Settings:

  1. Forward Periods - The number of periods to make the prediction over for the line.
  2. Percentage Modifier (Optional) - This lets you modify the estimate with a %. Great for creating worst and best case lines!

FAQ

Does it store any data?

This extension does not store any data. However it does use some services to email it

Can I use this inside an enterprise environment?

Yes! You can install the extension in the normal way through the QMC. If you want the writeback service installed locally on site for data storage purposes please contact adamcooke@webofwork.com.