Relationship Story: Current vs Previous Analysis


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

 

Narratives for Qlik supports three types of relationships, and with that additional content, it can produce richer, more insightful narrative content. The supported relationships are 'Comparison to Benchmark', 'Period Comparisons', and 'Portion Relationships'. This guide will walk through all three relationships in detail. 

 

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. The completed relationship will look like the 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.

 

 


Was this article helpful?
0 out of 0 found this helpful