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-qvw 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, 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. 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 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?