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.

inline_script_editor

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 in the clipboard. Please note the column headers are created automatically. Click Finish.

inline_scripting

Load Script

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

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

inline_data_chart
Advertisements