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.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?