Skip to main content

Store

This script function creates a QVD or a CSV file.

Syntax:  

Store[ *fieldlist from] table into filename [ format-spec ];

 

The statement will create an explicitly named QVD or CSV file. The statement can only export fields from one data table. If fields from several tables are to be exported, an explicit join must be made previously in the script to create the data table that should be exported.

The text values are exported to the CSV file in UTF-8 with BOM format. A delimiter can be specified, see LOAD. The store statement to a CSV file does not support BIFF export.

Arguments:  

Store arguments
Argument Description
*fieldlist::= ( * | field ) { , field } )

A list of the fields to be selected. Using * as field list indicates all fields. 

field::= fieldname [asaliasname ]

fieldname is a text that is identical to a field name in table. (Note that the field name must be enclosed b straight double quotation marks or square brackets if it contains spaces or other non-standard characters.)

aliasname is an alternate name for the field to be used in the resulting QVD or CSV file.

table A script label representing an already loaded table to be used as source for data.
filename

The name of the target file including a valid path.

  • absolute

    Example: c:\data\sales.qvd

  • relative to the QlikView document path.

    Example: data\sales.qvd

    If the path is omitted, QlikView stores the file in the directory specified by the Directory statement. If there is no Directory statement, QlikView stores the file in the working directory.

format-spec ::=( ( txt | qvd ) ) The format specification consists of the text txt for text files, or the text qvd for qvd files. If the format specification is omitted, qvd is assumed.

Examples:  

Store mytable into xyz.qvd (qvd);

Store * from mytable into xyz.qvd;

Store Name, RegNo from mytable into xyz.qvd;

Store Name as a, RegNo as b from mytable into xyz.qvd;

store mytable into myfile.txt (txt);

store * from mytable into myfile.txt (txt);

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