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 在資料載入編輯器中選取資料.

Fom 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.