跳到主要內容 跳至補充內容

Data binding

You use the assets from your Qlik Sense app as the data sources for your report. In your PixelPerfect report template, add data bindings for the app data and images you want to use in the report. Then, connect these data bindings to objects in your template. Data bindings are added in the Database icon with plus symbol Field List menu in the PixelPerfect designer.

Data bindings in the Field List

Image showing the 'Field List' menu expanded in the right side panel of the designer. The 'Field List' menu shows several example data bindings that have been added, such as levels and tables

What is a data binding?

A data binding is a reusable entity that you create in your report template, which contains the data from the app that you then use in your report content. When you add a data binding, the data source to which it refers becomes usable in your template.

A data binding can be reused across multiple objects and bands in your report. For example, you could add a table data binding for a specific pie chart in the app. This data binding could be connected to different objects in the app – for example, it could be used in a native PixelPerfect bar chart and a Cross Tab.

Types of data bindings

Data bindings are added in the Database icon with plus symbol Field List menu that is available on the right side panel in the designer. From this menu, you can add the following types of data bindings.

Levels

Add a field or chart in the app as a level data binding. Level data bindings are often used to bind to bands, looping the creation of distinct content filtered for each value in a dimension.

For more information about using levels to loop over dimensions, see:

You can also add a level data binding and connect it directly to an object in the template. For example, you want to add a label and use it as a title for a section containing looped charts.

Level data bindings are a key element of highly formatted PixelPerfect tables. For more information, see Creating highly formatted tables.

Images

Add images of your Qlik Sense visualizations directly onto your report.

For more information, see Adding images to the report template.

Tables

Add the source table for a visualization as a table data binding. The visualization does not have to be a table. Some Qlik Sense chart types – for example, treemap – cannot be added as table data bindings.

Table data bindings cannot be dragged and dropped directly from the Database icon with plus symbol Field List menu. Instead, they are mainly used to create the following:

Variables

Add variables from the Qlik Sense app as variable data bindings. Variables created in the script, as well as those created when editing sheets, can be used.

For more information, see Working with variables and expressions in your PixelPerfect template.

Expressions

Add calculated expressions, that are evaluated using the Qlik engine, as expression data bindings. For example, you could add an expression such as sum(Sales) as a data binding so that it can be used in native PixelPerfect labels with other natural language, or you could reference it in conditional formatting.

For more information, see Working with variables and expressions in your PixelPerfect template.

Adding a data binding

  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 the type of data binding you want to add. For details about each type and how it is used, see Types of data bindings.

  3. When applicable, expand the sheet containing the item you want to add, or search for items.

  4. Click the Plus icon next to the item.

    The data binding is added.

How to use data bindings

After you create a data binding, it is not automatically added to your report content. Instead, it is simply now available for use in the report content. To use a data binding in report content, it needs to be connected to an object or band in the template.

Depending on the type, you can use data bindings in the following ways:

  • If available, drag and drop the data binding directly from the Database icon with plus symbol Field List menu onto the canvas.

  • Add an object from the toolbox panel on the left side of the designer, and then connect it to the data binding. This process varies from object to object. The process usually involves selecting a Data Member and/or similar properties for the object.

  • You can sometimes reference the data binding in the Expression Editor.

For full details, refer to Visualizing app data in your report and related topics.

Refreshing data bindings

您可以重新整理用於以下用途的來源應用程式:

  • 作為層級新增的圖表的資料繫結物件。這些內容在 有加號的資料庫圖示 欄位清單 > 層級之下新增。

  • 原生 PixelPerfect 圖表、交叉表和走勢圖中使用的來源表格的資料繫結物件。這些內容在 有加號的資料庫圖示 欄位清單 > 表格之下新增。

這在下列情況下十分實用:

  • 自從建立資料繫結以來,維度和量值已新增至來源圖表或從來源圖表中移除。

  • 自從建立資料繫結以來,已在來源圖表中變更維度和量值的定義。

重新整理資料繫結來源可讓您在 有加號的資料庫圖示 欄位清單功能表中保留相同的物件,而無需在圖表設定變更時建立新的物件。

  1. 開始之前,請從範本中移除所有已移除或已更新的欄和欄位的執行個體。如果您的圖表更新僅新增欄或欄位,則不需要這麼做。

    這可能涉及以下任何一項:

    • 移除報告帶屬性中已移除欄位或欄的參考。

    • 對於圖表層級、走勢圖和交叉表,在選取層級後使用運算式編輯器移除任何已刪除欄位的參考。

    • 對於原生 PixelPerfect 圖表,移除物件屬性中任何已刪除欄的參考。這是在圖表設計工具中完成。

  2. 開啟設計工具右側面板中提供的 有加號的資料庫圖示 欄位清單功能表。

  3. 按兩下層級表格以便展開。

  4. 將游標暫留在要重新整理的項目上。

  5. 按一下重新整理 (更新欄位更新欄) 圖示。

    重新整理欄位清單功能表中的層級資料繫結

    按一下「更新欄位」圖示以重新整理層級資料繫結

    重新整理欄位清單功能表中的表格資料繫結

    按一下「更新欄」圖示以重新整理表格資料繫結

    如果圖表元素在重新整理過程中發生變化,則會出現一則通知,列出每項變更。變更可以包括新增、更新或移除的欄和欄位。

  6. 根據您的使用情況繼續進行範本開發。這可能涉及重新設定現有內容或新增內容。重新整理資料繫結後,新增的圖表欄現在可以從 有加號的資料庫圖示 欄位清單功能表中使用。

此頁面是否對您有幫助?

若您發現此頁面或其內容有任何問題——錯字、遺漏步驟或技術錯誤——請告知我們!