Skip to main content

Loading data from files

QlikView can read data from files representing a table, in which the fields are separated by a delimiter like commas, tabs or semicolons. Other possible formats are dif files (Data Interchange Format), fix files (fixed record length), HTML tables, Excel files, xml files and the native QVD and QVX files. In most cases, the first line in the file holds the field names.

Files are loaded by means of a load statement in the script.

Instead of typing the statements manually in the script editor, you can use the Table file wizard to generate the statements automatically.

In load statements, the full set of script expressions may be used.

To read data from another QlikView document, you may use a binary statement.