跳到主要内容 跳到补充内容

Using a level to loop over app data

You can loop and repeat the creation of report elements using data from the Qlik Sense app.

For an overview of levels, see Working with levels.

video thumbnail

High-level workflow

This is the recommended workflow for using levels in your PixelPerfect report. It covers some of the most common and simple ways to work with levels in the designer.

Part 1: Add data bindings

First, you need to add the data binding that will be used to cycle the generation of unique report elements. For example, if you want a separate section in the report for each region, you need to add a Region field as a data binding. Data bindings are added in the Database icon with plus symbol Field List menu.

This workflow assumes you already have content, in the applicable areas in the template, for which you want to create a level.

  1. Open the Database icon with plus symbol Field List menu available from the right-side panel in the designer.

  2. Click the plus icon next to Levels.

  3. Expand the sections to find the item you want to use. You can select a field from Fields, or an entire chart from any of the sheet sections.

  4. Click the Plus icon next to an item to add it as a data binding.

Part 2: Connect the data binding to the band

Next, you need to connect the level data binding to a band.

You cannot bind a level to the default Detail1 band, so you will need to create a new DetailReport band for content where you plan on using a level.

  1. Create a new DetailReport band. See Creating a new band.

  2. Select the new band, if not already selected.

  3. Open the Gear Properties menu from the right side of the designer.

  4. Under Detail Report Tasks > Data Member, select the item to use as the level.

Refreshing source data for data bindings

您可以刷新用于已添加为级别数据绑定的图表的源应用程序数据。这在以下情况下很有用:

  • 自创建数据绑定以来,维度和度量已添加到源图表或从源图表中删除。

  • 自创建数据绑定以来,源图表中的维度和度量的定义已更改。

刷新数据绑定源允许您在 带加号的数据库图标 字段列表菜单中保留相同的对象,而无需在图表配置更改时创建新的对象。

  1. 打开设计器右侧面板中可用的带加号的数据库图标字段列表菜单。

  2. 双击级别展开。

  3. 将光标悬停在要刷新的项目上。

  4. 单击刷新(更新字段)图标。

    刷新字段列表菜单中的级别数据绑定

    单击“更新字段”图标刷新级别数据绑定
  5. 根据您的用例继续进行模板开发。这可能涉及重新配置现有内容或添加新内容。刷新数据绑定后,新添加的图表列现在可以从 带加号的数据库图标 字段列表菜单中使用。

Example - Looping chart images over a dimension

请参阅此处的应用程序源示例:示例材料 - 应用程序中报告。上传应用程序和数据文件到空间,然后重新加载应用程序。即可完成示例。

Part 1: Add data bindings

  1. Create a new PixelPerfect template.

  2. Open the Database icon with plus symbol Field List in the designer.

    Field List menu in the PixelPerfect designer

    The 'Field List' menu expanded from the right side panel in the PixelPerfect designer
  3. Click the plus icon next to Levels.

  4. Expand Fields, and click the Plus icon next to the Region chart.

    The data binding is added.

  5. You are brought back to the main Database icon with plus symbol Field List menu. Click the plus icon next to Images.

  6. Expand the Dashboard sheet, and click the Plus icon next to the Top 5 Customers chart.

    The data binding is added.

    Field List menu showing newly created level and image data bindings

    The 'Field List' menu showing the newly created data bindings added for use: a 'Region' level and a 'Top 5 Customers' image.

Part 2: Add band and content

  1. On the design surface, right-click the Detail1 band and select Insert BandDetailReport.

  2. Open the Database icon with plus symbol Field List menu, and double-click Levels to expand it.

  3. For Region, expand the level object and drag the Region field within it onto the DetailReport1 band.

    Position the label at the top of the band.

  4. In the Database icon with plus symbol Field List menu, expand Images and drag Top 5 Customers onto the DetailReport1 band. Place it below the Region label.

You can customize and style the content as desired.

Part 3: Bind the level to the band

  1. Click the DetailReport1 band.

  2. Open the Gear Properties menu from the right side of the designer.

  3. Under Detail Report Tasks > Data Member, select the Region field.

    Report template with content and DetailReport1 band bound to level

    Report template with Detail1 band selected, and its properties opened on the right side panel. The properties show that the data binding has been connected to the band under 'Data Member'
  4. In the top right corner, click Save template.

  5. Click Preview report. Download the report and open it.

Report preview

Generated report showing several sections, one for each region, with a chart under each region heading

本页面有帮助吗?

如果您发现此页面或其内容有任何问题 – 打字错误、遗漏步骤或技术错误 – 请告诉我们!