Using the Quill for Qlik extension, you can assign relationships between measures in narratives about multi-measure visualizations. 


Quill for Qlik supports two types of relationships that produce richer, more insightful narrative content. The supported relationships are Actual vs. Benchmark and Current vs. Previous Period. This guide will walk through Current vs. Previous analysis.


Note - You can apply multiple relationship stories at the same time (in the same narrative)



Where is the Current vs Previous Analysis Useful?

  • Change in KPIs - better understand if your KPIs from prior periods are increasing, decreasing, or remaining consistent
  • Analytics In Language - identify trends over time without needing to look at the raw data


Comparison of Time Periods


In this example, we have a bar chart that is measuring the same metric, but across two different time periods. While the bar chart is across a discrete x-axis of product groups, the goal of the chart is compare the performance of those products over the two time periods. We want to answer questions such as: Which product's revenue grew the most? Which product's revenue fell the most? Using this relationship type results in a narrative containing this analysis and insight.



1. Open up the narrative settings by clicking the gearbox icon. After clicking 'Relationships' in the left sidebar, you will see the available relationship types you can apply. Click 'Current/Most Recent vs. Previous Period' to identify the related measures and supply other information about the relationship.


2. Use the drop downs to select which measure reflects the current/most recent period and which reflects some period in the past. After inputting the measures, you can input how many 'periods' in the past the previous measure is and how those periods should be referenced. See below:



3. You can click the "x" on the right side in order to remove this relationship. Once you click "Close", a new narrative will be generated.


This relationship can also be applied to continuous narratives.