All Products
Search
Document Center

Quick BI:Configure a Workbook

Last Updated:Feb 12, 2025

You can configure a workbook in the workbook configuration area through a series of operations.

Prerequisite

You have logged on to the Quick BI console and created a workbook. For more information, see Create a Workbook.

Main Toolbar

The main toolbar at the top allows you to:

image

  • Customize the workbook name

  • Bookmark the workbook

  • Switch between PC and mobile views

  • Lock or unlock the workbook

  • Replace the dataset

  • Configure global parameters

  • Adjust page settings

    image

    • Display a watermark

    • Enable workbook export

    • Enable the analysis mode switch to ensure that Preview supports analysis mode.

    • Perform formula calculations after data retrieval

    • Delayed formula calculation: Enable this option to postpone formula computations until all dependent datasets have been loaded. You can select either First screen sheet or Entire workbook.

    • Remember query conditions

    • Set global parameters. For more information, see Configure Global Parameters.

  • Switch between Preview and Edit modes

    • To enter Preview mode, click the Preview option. This mode supports previews for both PC and Mobile interfaces.

    • View and manage grouping settings in Preview mode

      Untitled

  • Save changes

  • Save and publish or republish the workbook

  • Export the workbook in Excel or PDF formats

    Note

    Note: PDF export does not include charts. For charts, export to Excel and then convert to PDF.

  • Save as, restore previous versions, open in a new tab, manage collaborative permissions, unpublish, and toggle between light and dark themes. image.png

Menu

The workbook menu allows you to:

Import .xlsx files

Edit

Format

4. Data

⑤ To view details, click here.

image.png

Import Xlsx

Import xlsx files to overwrite current workbook data. Untitled.gif

Edit

Edit data content within the workbook. image.png

Insert

Insert various elements into the workbook:

image.png

Format

Set formats for workbook content. image.png

Set data format

Set font and text size

Set text style

Set cell style

Add rules to data results. For details, see Conditional Format.

-

Data

Perform operations like sorting, filtering, and data lookup. image.png

Configuration item

Description

Sort

Sorting supports ascending order, descending order, and custom sorting. For more information, see Sort.

Filter

Supports filtering data in the table and sorting values in ascending and descending order.

image

Data lookup

Supports searching for data by entering keywords.

image

View

Adjust view settings for workbook content. image

Configuration item

Description

Hide/Show gridlines

Support hiding or showing gridlines.

10.gif

Note

Hiding gridlines supports saving.

Hide selected rows/columns and unhide

Support hiding selected rows, hiding selected columns, or unhiding.

11.gif

Freeze to current row

After freezing, the current row is fixed and does not shift with the workbook.

12.gif

Freeze to current column

After freezing, the current column is fixed and does not shift with the workbook.

13.gif

Freeze to current row and column

After freezing, the current row and column are fixed and do not shift with the workbook.

14.gif

Unfreeze

After unfreezing, rows or columns are no longer fixed, and the workbook can shift entirely.

15.gif

Toolbar

Beyond the configurations mentioned, you can also manipulate the data content using the toolbar operations.

image.png

① Revoke, recover, format painter, and clear formatting.

② Configure the data format.

3. Configure the text format.

④ Configure cell style, including color fill and cell merging.

Define the cell subject.

⑥ Apply conditional formatting.

⑦ You can set filters, sort data, apply freeze panes, and enable paging.

⑧ To create a card view, follow this link.

⑨ To insert content such as charts, data fills, and functions, follow these steps.

⑩ Additional features such as pivot tables, images, dropdown boxes, hyperlinks, notes, query controls, and search capabilities.

Insert Dataset

You can insert a dataset table and free-style cell into your document. For more information, see Create a Workbook.image.png

Sheet Page Settings

Configure the workbook's sheets as follows.image.png

Configuration item

Description

Rename

Rename the current sheet page.

Copy

Copy the entire workbook (including different blocks, data panel configuration formats, functions, and data source connections) to create a new sheet page.

Delete

Delete the current sheet page.

Border color

Set the border color of the current sheet page.

image

Hide classic workbook

Hide the current sheet page.

Set Cell Subject

  • Apply system-provided themes.

    25.gif

  • Create custom themes.

    26.gif

Conditional Format

Create conditional formatting rules to format cells based on specific conditions. Follow these detailed instructions:

Create Conditional Format

  1. Select the range of cells or dataset fields in the workbook for conditional formatting.

    Area type

    Selection operation instructions

    Cell range

    Directly select the cell area in the table that requires conditional formatting. After selection, click Conditional format > Create new conditional rule in the toolbar.

    112

    Dataset field

    In the Style panel of the dataset, enable conditional formatting and select the fields that need conditional formatting as required.

    112

  2. In the Create new rule window, you can set up the specific parameters for conditional formatting, which include Style type and Conditional rule. image

    Configuration content

    Configuration instructions

    Highlight text/background

    • Application instructions: Configure rules to highlight cell text color and background color to visually emphasize key data in the table, helping readers quickly detect and understand important information.

    • Operation instructions: You can configure the calculation method of conditional rules (⓵), text color, and background color (⓶) according to actual needs. Custom calculation formulas are supported. For detailed instructions on using custom formulas, see Common Custom Formula Applications. image

    • More settings: When the object of the conditional format is a dataset field, it supports quickly applying the configured background color conditional rule to the entire row and choosing whether to apply it to summary data.

    Data bar

    • Application instructions: Express cell values in the form of visual length and color, and set display rules for the format to more intuitively show the relative size or comparison relationship of data.

    • Operation instructions: You can configure the color of positive and negative values of data bars (⓵), whether to enable gradient effects (⓶), and the maximum and minimum values (⓷) according to actual needs. image

    • More settings: When the object of the conditional format is a dataset field, it supports choosing whether to apply it to summary data.

    Icon

    • Application instructions: Display specific mark icons in the cell based on the result of value comparison to clearly show the size relationship between current data and target data, thereby visualizing the trend of data changes.

    • Operation instructions: You can select a set of mark icon styles (⓵) and set comparison rules and target values (⓶) according to actual needs; you can also customize mark icons for each comparison rule (⓷). image

    • More settings: When the object of the conditional format is a dataset field, it supports choosing whether to apply it to summary data.

  3. (Optional) Within the Conditional format window, you can review the established conditional rules. This window allows you to modify, remove, or append operations to the conditional format. image.png

Common Custom Formula Applications

Upon selecting the Highlight text/background style type, the conditional rule's calculation method can be set to Custom formula. This allows for the input of rule formulas tailored to specific business calculations and scenarios. Below are examples of common scenarios with corresponding formulas, illustrated using a company's revenue statistics table.

Note

When writing custom formulas, consider the following:

  • Select the cell range or dataset field for the conditional format. For example, select the revenue column for conditional formatting.

  • Formulas should start with '=' and return TRUE or FALSE, where TRUE applies the specified format.

  • Decide between using relative (A1) or absolute ($A$1) references in your formula.

image

Scenario 1: Mark the Current Cell by Comparing it with the Values of other Cells

Highlight cells where revenue is less than 50% of the target.

  • Formula: =I3<=(H3*0.5)

  • Instructions: Use standard operations to write the formula. Use a relative path for automatic cell reference adjustments.

  • Instructions for Operation and Effect: Once you have finished writing the custom formula and chosen the text and background colors for the cell, click OK. The conditional formatting will then be applied to the selected range of cells. image

Scenario 2: Mark the Current Cell Based on the Values of other Cells

Highlight cells with revenue between 20 and 40 million.

  • Formula: =AND(I3>2000,I3<4000)

  • Instructions: Use the AND function for multiple conditions. Use a relative path for automatic cell reference adjustments.

  • Instructions for Operation and Effect: Once you have written the custom formula and configured the cell's text and background color, click OK to apply the conditional formatting to the selected range of cells. image

Scenario 3: Find the top N Largest or Smallest Values in a Column

Highlight cells with the top 2 revenue rankings.

  • Formula: =I3>=LARGE(I:I,2)

  • Instructions: Use the LARGE function to find the second largest value in the revenue column. Use a relative path for automatic cell reference adjustments.

  • Instructions for Operation and Effect: Once you have finished writing the custom formula and have set the text and background color for the cell, click OK. The conditional formatting will then be applied to the chosen range of cells. image

Sort

Supports various sorting methods.

image

  • Choose to sort the current area or extend the sorting to adjacent areas.

    image

    Note

    Note: Extended area sorting is not possible with vertically merged cells.

  • Custom sort

    image

    Set primary and secondary sorting criteria, which can be reordered as needed.

    ② It supports the establishment of a primary criterion and the addition of multiple secondary criteria, which you can reorder through drag-and-drop.

Create Paging

  • Click the image icon on the toolbar to access the paging configuration. image

    Configuration Item

    Description

    Please select a dataset

    Select the dataset for which you need to create paging.

    The number of entries per page

    Set the number of entries displayed per page. Currently supports displaying 10, 20, 30, 50, 80, and 100 entries. image

    Display position

    Supports setting to always display or hover display.

    • Always display effect: image

    • Hover display effect: 11电子

  • Edit the pager as illustrated. image

  • Delete the pager as shown. image

Add a Dropdown List

Quickly filter categories and fill in data using a dropdown list. Follow these steps to add one:

On the workbook editing page toolbar, click Dropdown list.

On the settings page, add tags for data entries.

Click Confirm.image.png

The result is shown below:

27.gif

Note
  • Separate multiple tags with commas.

  • If you see the message This Operation Will Affect The Data Of Nearby Datasets And Is Not Allowed!, copy the content to another area of the workbook before proceeding.

Insert Charts

Insert charts based on workbook data. Supported chart types include line, column, pie, gauge, radar, scatter, funnel, and polar diagrams.

  1. Select the data area in the workbook.

  2. Choose a chart from the toolbar as shown below.

    1. Path 1: Click Insert -> Chart -> Select a chart type.

      image.png

    2. Path 2: Select Chart Insert in the toolbar -> Choose a chart. image

  3. The chart will automatically be displayed in the workbook. In the Chart Design section on the right, you can select the desired chart style.

    For example, here's how to set up a pie chart. image

    For more information, see Visualization Chart Overview.

Insert a Pivot Table

A pivot table allows for Excel-like data summarization and analysis.

  1. Select the data area in the workbook.

  2. Use the toolbar to create a pivot table as shown in the figure below.

    1. Path 1: Click Menu -> Insert -> Pivot Table.

      image

    2. Path 2: In the toolbar, first click More, then select Pivot Table.

      image

  3. In the pivot table creation interface, complete the setup as illustrated.

    image

    1. Select an area

      1. The area defaults to the selection made in step 1. You can directly adjust the area range in the provided box or click the image icon to choose a different area.

        image

      2. Alternatively, use a dataset to create a pivot table.

    2. Choose where to insert the pivot table.

      You can opt for a new classic workbook or use an existing one. The latter allows for direct input or the selection of an insertion area by clicking the image icon.

      image

    3. Confirm to complete the pivot table creation.

      Perform data calculations, summarization, and analysis.

      111.gif

Right-click Operation

Right-click to access operations such as cut, copy, paste, insert rows or columns, delete selections, purge, and add comments. image

Configuration item

Description

Cut/Copy/Paste

Cut, copy, or paste data in the current cell.

Selective paste

Support pasting values only, formats only, or formulas only.

Insert a row or column

Support inserting a row above or below, or inserting a column to the left or right.

Delete selected rows or columns

Delete rows or columns of the selected data.

Clear

Purge all, content, format, or comments.

Add comments

Add comment information to a specific value.

image

Preview

Once the workbook is published, you can preview it by clicking the image icon.

image

Toggle the parse pattern during preview.

  • Disable Parsing Pattern

    When disabled, the position border is hidden, and you can export, favorite, or share.

    image.png

    Edit mode is also accessible.

  • Activate Parsing Pattern

    image.png

    When the parse pattern is enabled, the workbook toolbar appears, allowing you to export, add to favorites, and share. You can perform related operations via the menu and toolbar.

Switch between Light and Dark Theme Modes

  1. Navigate to the workbook page.

  2. On the workbook editing page, you can click the image.png icon in the upper right corner, then select the icon at the bottom to toggle between light and dark themes for the workbook.

    image.png

    Note

    Switching between light and dark themes applies to the entire account, rather than individual modules. For instance, when you set the workbook to light mode, other modules capable of theme switching, such as dashboards and data reporting, will automatically adopt the light mode as well.

    Light Mode

    image.png

    Dark Mode

    image.png

    System Follow

    Adopt the system style in custom configurations.

    image

    For more information, see System Theme Customization.

    Note

    Only tenant management can set the system style in custom configurations. Module-level modes take precedence over organization-level modes.