How to Cycle Through a Chart with a Variable as a Dimension in a Mail & Deploy PowerPoint Report?

You wish to cycle through a chart in a Mail & Deploy PowerPoint report where the dimension is defined by a variable. Manually assigning values to the variable on each slide did not work as expected.

Solution:

Instead of manually assigning values, you can use a Repeater with an expression as the source. This approach dynamically cycles through the values and applies them as needed.

Steps to Set Up the Repeater:

1. Create a Repeater with an Expression Source:
   • In the Repeater settings, select Expression as the source type instead of using a Dimension.
   • For example, if you want to repeat for specific values such as "Industry," "CIP Direct Prep.," etc., use an expression like: CreateList("Industry", "CIP Direct Prep.", "Value3", "Value4")
     
     
     

Example Use Case:

You want to display the last three months in your chart. The expression for the Repeater could be:

CreateList (Date.Now.Month, Date.Now.AddMonths (-1).Month, Date.Now.AddMonths (-2).Month)

The chart will then dynamically update for each slide, reflecting the different months.

Additional Resources:

For a more detailed walkthrough, refer to the tutorial video here:
Mail & Deploy Tutorial - Using Repeaters with Expressions

---

By using a Repeater with an Expression source, you can efficiently cycle through a chart with a variable as a dimension, eliminating the need for manual assignments.

• Related Articles

• What is Report Culture Awareness, and how does it impact Mail & Deploy reports?

  FIRST CREATED ON 30 Apr 2020 I AUTHOR Emma Camacho A culture is a set of rules that specify how numbers and dates are formatted (Windows Regional Settings). Generally speaking, the culture defines in what format numbers and dates are being presented ...

• How to synchronize cell insertion in an Excel report in Mail & Deploy (with example)?

  FIRST CREATED ON 31 Jan 2024 I AUTHOR Emma Camacho Synchronizing cell insertion in an Excel report within Mail & Deploy ensures that your data is accurately aligned and formatted. Here's an example to guide you through the process: If you need a ...

• Handling Date Variables in Mail & Deploy Reports

  You have a date variable in Qlik (formatted as DDMMYYYY), but when used in Mail & Deploy, it gets converted into a number. For example, the file output appears as File_45014.xlsx instead of File_29032023.xlsx. Solution: To resolve this issue, you can ...

• How to create an Excel report using Snowflake as a data source in Mail & Deploy (with example)?

  FIRST CREATED ON 5 Mar 2024 I AUTHOR Emma Camacho Creating an Excel report using Snowflake as a data source in Mail & Deploy allows you to leverage powerful data analysis capabilities. Here's an example to help you get started: Use case: Display ...

• Creating Custom Calculations in Excel Reports Using Mail & Deploy?

  You want to create an Excel report using Mail & Deploy. Specifically, you have a table spanning columns A to K and need Column G to display the result of Column I × Column B, instead of using the result directly from the Qlik app. Solution: While the ...