メイン コンテンツをスキップする

Structuring an app using sheets

Sheets structure your ideas and purpose of your app. When you create an new app, it is good practice to first build a structure of empty sheets, where each sheet represents an idea or a goal. This gives a good overview of the app.

Overview

For example, you are creating an overview of your company's key metrics, sales, and margins by state, region, and product. Instead of having all this information in one place, you could structure it by having one sheet for each purpose.

Each sheet has a purpose and an idea of its own.

Three different sheets.

A sheet is where charts and tables for data visualization are placed. An app can include several sheets. The selections that you make affect visualizations, regardless of which sheets they are on.

An example of a sheet with boxes on the left to select and filter out the data to be presented in the visualizations on the right.

Sheet with visualizations.

Creating a new sheet

You can create a new sheet from the app overview or from the sheet navigator.

ヒント: You access the sheet navigator from the sheet view by clicking 4 in the toolbar.

次の手順を実行します。

  1. From the app overview, click 4 to view the sheets.
  2. Click P or Create new sheet.
  3. Give your sheet a title and add a description.
  4. Click outside the text area to save the title and description.

A new sheet is created.

Changing the title and description of a sheet

You can change the title and description of your sheets. You can either use a fixed sheet title, or a dynamic sheet title based on an expression.

次の手順を実行します。

  1. アプリ概要で 4 をクリックし、シートを表示します。
  2. 以下のいずれかを行います。
    • グリッド ビュー ì の場合は、シート タイトルを選択し、@ をクリックします。
    • リスト ビュー î の場合は、@ をクリックします。
  3. [タイトル] と [説明] を編集します。
  4. Click outside the text area.
変更内容を保存します。
ヒント: You can also change a sheet’s title and description in the Sheet properties panel.

Using a dynamic sheet title

You can set a dynamic sheet title based on an expression in the Title expression property of the sheet properties panel. You can use any valid chart expression. For more information, see ビジュアライゼーションにおける数式の使用.

If you set a dynamic sheet title, the fixed title (Title) is not used.

Changing the sheet thumbnail

You can replace the default thumbnail, to make it easier to distinguish between sheets in the app overview and in the sheet navigator. You can use one of the default images, or an image of your own.

次の点に注意してください。

  • The following formats are supported: .png, .jpg, .jpeg, and .gif.
  • The optimal aspect ratio of a thumbnail is 8:5 (width:height).
  • You can only add or change the thumbnail of an unpublished sheet.

次の手順を実行します。

  1. アプリ概要で 4 をクリックし、シートを表示します。
  2. 以下のいずれかを行います。
    • グリッド ビュー ì の場合は、シート タイトルを選択し、@ をクリックします。
    • リスト ビュー î の場合は、@ をクリックします。
  3. デフォルトのサムネイル上にある 0 をクリックします。

    [メディア ライブラリ] が開きます。

  4. Click on a folder in the media library, for example In app or Default.

  5. Select the image you want to use as a thumbnail for the sheet and click Insert.
  6. 編集を中止するには、m をクリックします。

The image you selected is now used as a thumbnail for the sheet, and is visible in the sheet navigator and in the app overview.

ヒント: You can also change a sheet’s thumbnail in the sheet navigator at the top right or in the Sheet properties panel.

次の形式がサポートされています。pngjpgjpeg、およびgif

Qlik Sense の場合: メディア ライブラリの [アプリ内] フォルダーに画像をアップロードできます。画像をデフォルト フォルダにアップロードするには、Qlik Management Console を使用する必要があります。

Qlik Sense Desktop の場合: コンピューター上の次のフォルダーに画像を配置できますC:\Users\<user>\Documents\Qlik\Sense\Content\Default。メディア ライブラリの [default] (既定) フォルダーから画像を使用できます。アプリをインストール間で移動すると、アプリで使用する画像はアプリと一緒に qvf ファイルに保存されます。新しい場所でアプリを開くと、画像はアプリのメディア ライブラリの [アプリ内] フォルダーにあります。

Fore more information, see Managing a Qlik Sense site: Uploading objects to content libraries.

Changing the grid sizing of a sheet

You can adjust the grid sizing of the sheet to be able to fit more visualizations on a sheet, or have more control over how visualizations are positioned. The grid displays when you are adding, moving, or resizing a visualization.

Grid size can be changed in the Sheet properties pane

The sheet properties pane

次の手順を実行します。

  • Change the Grid spacing setting in Sheet properties from Wide (the default option) to Medium or Narrow.

The sheet grid is now more dense and the grid squares are smaller.

Customizing sheet size

By default, Qlik Sense uses a responsive layout for sheets that adjusts the sheet to the dimensions of the user’s screen. You can set a custom width and height for the sheet if you want to use a non-responsive layout for your sheets. This ensures that your dashboard will be presented to users exactly as you created them, with no adjustments for responsiveness. You can set the height and width of a sheet anywhere between 300 pixels and 4,000 pixels.

When a sheet is using a custom size, you can change the grid spacing, but you cannot use Extend sheet to change the size.

注:

When a custom sheet is exported, the exported sheet is exported as a Responsive sheet. For optimal default sheet thumbnails, keep your custom size ratio to 8:5 (width:height).

Custom-sized sheets may have a lower quality PDF output if the sheet is too large to clearly display on a single PDF page.

次の手順を実行します。

  1. Change the Sheet size setting from Responsive to Custom.
  2. Enter a width for the sheet in pixels.

  3. Enter a height for the sheet in pixels.

Changing the small screen layout

By default, sheets are displayed in List view when viewed on small screens. You can change them to display as a grid. Sheets must be set to responsive layout to display as grid on small screens.

A sheet viewed on a small screen in List view (left) and Grid view (right)

Comparison of sheet list view versus grid view on smaller screens

Grid view shows a small preview of your visualizations. List view only shows the visualization titles.

次の手順を実行します。

  1. Under Sheet properties, go to Small screen layout.
  2. From the drop-down, select Grid view.

Extending the sheet area

You can extend the area of a sheet vertically if you need to add more visualizations than what can fit on a screen.

注:

Exported extended sheets may have a lower quality PDF output if the sheet is too large to clearly display on a single PDF page.

次の点に注意してください。

  • You need to activate Extend sheet under Sheet properties.
  • Each extension adds 50% of the original sheet height.
  • If you have visualizations that scroll, this can interfere with scrolling of an extended sheet. You should leave some empty space that allows for scrolling when you design the sheet.

You can extend the sheet in two different ways:

次の手順を実行します。

  • Drag an object to the bottom of the sheet and drop it on the drop zone that appears.
  • Toggle Extend sheet under Sheet properties.

The sheet is now expanded by 50% of the original height. You can scroll vertically in the sheet to access all content.

Adding actions to sheets

You can add actions to sheets that trigger when users navigate to those sheets. For example, you could automatically clear selections in the app when users navigate to a particular sheet.

For more information, see シートへアクションを追加.

Copying, replacing and moving items on sheets

You can copy, replace, and move items on a sheet and between sheets. You can do this in the following ways:

  • Using the edit bar on the sheet (µ, and ).
  • By right-clicking and selecting Cut, Copy and Paste.
  • With the keyboard shortcuts Ctrl+C, Ctrl+X and Ctrl+V.

Duplicating a sheet

You can duplicate any sheet, regardless of whether it is a sheet that belongs to the app or a sheet you have created yourself. The purpose of duplicating sheets is to save time by reusing content, and to allow you to modify the duplicate so that it fits your needs better.A duplicated sheet contains the same visualizations as the original sheet, and is linked to the same master items. The duplicated sheet is a standalone sheet with no connection to the original sheet. Duplicated sheets appear under My sheets in app overview and in the sheet navigator.

You can duplicate a sheet in the following ways:

  • Click Duplicate in the shortcut menu of a sheet in the app overview or in the sheet navigator.
  • Click Duplicate sheet in the global menu in the app overview or in sheet view.