Skip to main content Skip to complementary 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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com