Manual entry in Add data enables you to enter data into an editor in Qlik Sense, and then add it as a table in Data manager.
Manually entering data is useful if you want to use a limited set of data from another source. For example, if you only wanted a selection of rows from an Excel spreadsheet or from a table on a webpage to be loaded as a table into Data manager, you could copy and paste the selected data into Manual entry and then add it as a table in Data manager. It is also useful if you have a small amount of data that might be faster to add manually than importing from another data source.
To add data manually, you open Add data, select Manual entry, enter your data into the table, and then add the table to Data manager. The table editor starts with one row and two columns, but as you add data to the table, additional empty rows and columns are automatically added to the table.
Manual entry does not automatically save as data is entered. Data entered may be lost if the screen is refreshed, if the session times out, or if the connection is lost before the data is added to Data manager.
In addition to typing data, you can copy and paste it from other sources. Manual entry preserves the columns and rows of data copied from Excel tables.
There are a number of keyboard shortcuts you can use to work effectively and easily in Manual entry. Shortcuts behavior varies depending if you are selecting cells, rows, or columns, or if you are editing cells in the table. The following table contains the selecting shortcuts:
|Navigates between cell selection
|Moves the cell selection right. If no cell exists to the right, it moves to the first cell in the next row.
|Moves the cell selection left. If no cell exists to the left, it moves to the first cell in the previous row.
|Toggles to editing mode
|Deletes the current selection
The following table contains the editing shortcuts:
|Moves the cursors in the cell.
|Commits the edit and moves to the next cell to the right
|Commits the edit and moves to the previous cell to the left
|Commits the edit and moves to the next cell below
|Commits the edit and moves to the previous cell above
|Cancels the edit and toggles to selecting mode
Tables created using Manual entry can be edited later to add or remove content. For more information, see Updating a table from the data source.
Adding data manually
Do the following:
- Open an app.
Open Data manager and then click Add data > Files and other sources.
You can also click Add data in the menu.
- Under In-App, click Manual entry.
- Type a name for the table.
In the table editor, enter your data.
Double-click a cell to start entering data in the cell.
While editing a cell, clicking any other cell in the table commits your edit and selects the other cell.
- When your data is complete, click Add data.
The table is added to Data manager.
If your data includes city or country geographic information, the following QVD files might automatically be added to the current space:
These files are used to provide additional geographic data for the locations included in your added data. Qlik Sense manages and updates these files as necessary. If they are deleted, they are automatically added back after the next reload.