Skip to main content

File Wizard

The File Wizard automatically appears when opening a file or an HTML table using the Table Files... button in the Data page of the Tool Pane in the Edit Script dialog. The wizard also opens when a non-QlikView document file is opened from the File menu.

File types that QlikView can recognize are delimited text files (e.g. csv files), fix record files, dif files, Excel files, HTML files and XML files. These file types are referred to as Table Files.

Files can be loaded from the local network or directly from the Internet.

To load a file stored on a local network, use the Table Files button in the Edit Script dialog. If the file has a file extension of a table file, .csv, .txt, .tab, .skv, .fix, .dif, .htm, .html, .shtml, .xhtml, .php or .asp, the file will be shown in the Open Local Files dialog. It is possible to open the file even if it has a different extension; just set Files of Type to All files (*.*) in the Open Local Files. The content must however still be such that QlikView can interpret it. Whether or not QlikView can, is a different matter from what extension the file has.

To load a file directly from the Internet, paste the URL (previously copied from the web browser) into the text box named File Name in the FTP browsing dialog and click Open.

Once a file has been selected, the file wizard opens. It contains five pages: Source, Type, Transform, Options and Script. Since one very rarely needs to change anything on the Source page, the wizard starts on the Type page. The <<Back and the Next>> buttons will take the user from one page to another.

On the Type and Options pages there is a preview in which it is possible to see how QlikView has interpreted the file. The Script page makes it possible to set how the script is presented in the Edit Script dialog.

The Finish button will close the wizard and generate a load statement in the load script.

To load a file stored on a local network, use the Table Files button in the Edit Script dialog. If the file has a table file extension, e.g. .csv, .txt, .tab, .skv, .fix, .dif, .htm, .html, .shtml, .xhtml, .php or .asp, the file will be shown in the Open Local Files dialog. It is possible to open the file even if it has a different extension; just set Files of Type to All files (*.*) in the Open Local Files dialog. The content must however still be such that QlikView can interpret it. Whether or not QlikView can, is a different matter from what extension the file has.

To load a file directly from the Internet, paste the URL (previously copied from your web browser) into the text box named File Name in the FTP browsing dialog and click Open.

Once a file has been selected, the file wizard opens. It contains five pages: Source, Type, Transform, Options and Script. Since one very rarely needs to change anything on the Source page, the wizard starts on the Type page. The <<Back and the Next>> buttons will take you from one page to another.

On the Type and Options pages there is a preview in which you can see how QlikView has interpreted the file. The Script page lets you set how the script is presented in the Edit Script dialog.

The Finish button will close the wizard and generate a load statement in the script.

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