QlikView – Inline Data

Data can be entered into a QlikView document by directly typing or pasting it. This feature is a quick method to get the data from the clipboard into the QlikView. The script editor provides this feature under the Insert tab.

Script Editor

To open the Inline data load option, we open the script editor and go to Insert → Load Statement → Load Inline.

Inserting Data

On opening the above screen, we get a spreadsheet-like document where we can type the values. We can also paste the values already available on the clipboard. Please note the column headers are created automatically. Click Finish.

Load Script

The command, which loads the data, is created in the background which can be seen in the script editor.

Table Box Data

On creating a Table Box Sheet Object, we see the data that is read from the Inline data load option.

Leave a Reply