跳到主要内容
关闭通告横幅

Adding data from uploaded data files

You can upload certain file types and load that data in Data load editor or Data manager.

To make data from files available in your app, you must:

  • Upload your data files to your cloud. Each data file must be 500 MB or less.
  • Add the data to your app. This is a preliminary step that allows you to select and prepare the data that you want to load.
  • Load the data into your app. When you are done selecting and preparing the data, you can load the data into your app. After you load the data, you can use it to create visualizations in your app.
备注: This functionality is not available in Windows.
备注: DataFiles 连接的文件扩展要区分大小写。例如:.qvd

Uploading your data files to your cloud

You can upload data files to your cloud from the DataFiles window. There are different ways to open this window.

In a new app

执行以下操作:

  1. Open the app.
  2. Click Add data from files and other sources.
  3. In the left menu, click Data files.
  4. Under Folder shortcuts, click DataFiles, and then upload a data file.

In an existing app

执行以下操作:

  1. Open the app.
  2. In the top menu, click the Data tab, and then click Add data.
  3. In the left menu, click Data files.
  4. Under Folder shortcuts, click DataFiles, and then upload a data file.

In the Data load editor from an existing DataFile connection

执行以下操作:

  1. Open the app.
  2. Open the Data load editor.
  3. Go to the Data connections window on the right. You will see folders from personal and shared spaces, you can access.
  4. Choose a DataFiles folder, and click Select data.

After you have uploaded a file to your cloud, you can add the data to you app, and then load data into your app.

Loading data into your app

警告:

不要在数据管理器中添加在数据加载编辑器内具有相同名称和相同列,且已作为脚本化表格添加的表格。

In Data manager

备注: In Data Manager, data files can only be uploaded or read from your personal space or the current space of the app.

执行以下操作:

  1. Open an app.
  2. 打开数据管理器,然后单击 ú。您也可以单击 ¨ 菜单中的添加数据。 Adding data allows you to select and prepare your data before you load the data into your app.
  3. Click Data files.
  4. Choose the file that contains your data. Qlik Sense provides you with a preview of your data.
  5. Select the tables and fields to load.

  6. 点击添加数据以在数据管理器的关联视图中开启数据。这可让您继续在数据管理器中添加数据源、转换数据以及为表格建立关联。

    在您点击添加数据时,默认情况下会启用数据分析。数据分析执行以下工作:

    • 建议数据关联。
    • 自动限定表格之间的共用字段。此操作会基于表格名称添加唯一的前缀。
    • 将日期和时间字段映射至 autoCalendar。

    表格不会根据共用字段名称自动关联。您可在关联视图中关联表格。

    提示: 如果您想直接将数据载入您的应用程序,点击 ¥,然后禁用数据分析。此操作还会在您添加数据时从数据源重新加载所有现有数据。表格将根据共用字段名称自动关联。将不会创建日期和时间字段。
  7. 准备好数据后,单击加载数据。如果检测到严重问题,则需要在数据管理器中先解决这些问题,然后才能将数据加载到应用程序。

From a data connection in the data load editor

You can go to Data Connections, and use the Data SelectionSelect data dialog to select data to load.

For more information, see 在数据加载编辑器中选择数据.

From a file by writing script code

Files are loaded using a LOAD statement in the script. LOAD statements can include the full set of script expressions. To read in data from another Qlik Sense app, you can use a Binary statement.

For more information, see Load.

Uploading an updated data file

To update data in an app, you can upload an updated data file with the same name as the file you that you previously uploaded. When prompted, choose the replace the previous file. After you have uploaded the data file, you can reload the data into your app.