Data Export

Choose elements

The basic enablement of the data export happens within each table element you choose for your report. 

Whether you create a report just for data export purposes or you'd like to extract some data from certain elements of a PDF report, first you go to the properties of the respective table and enable this feature:

1. On your Sense sheet, select the ancoreShare button for which you want to enable the data export and go to Report Elements.
2. Choose a table object from your added elements for which you want to enable the data export or add a new table object.
3. In the respective table object, go to Data Export in the table properties and Enable Data Export.

Repeat this for all table elements of your report whose data should be exported by this feature.
After this basic enablement you can proceed to set the file type, filename, and the sheet title when exporting to Excel.

File Type

You can choose between Excel and CSV as an output format for your data exports. 

XLSX (Excel) is a rich format and allows to add multiple tables to a singe file, putting each element on a separate Excel sheet. 

Whereas CSV (Delimiter Separated) always creates a separate file for each table element, but all of them are generated at once (your browser might ask you to allow the download of multiple files).

Filename (Element)

By default all data export files are named after the Qlik Sense object ID of the respective table element. This also means that by default each table element is exported in a separate Excel or CSV file, named after its ID.

Only set the custom name for the file here without the file extension (i.e. ".xlsx" or ".csv"), it will then be applied to both Excel and CSV exports.

In order to put multiple table elements in a single Excel sheet, set the same filename for each. Table elements with the same filename property will be collectively exported in one Excel file.
However, when the export type is set to CSV, each table element will create a separate CSV file regardless of the filename. 

There is also the option to set a filename for the data export globally for the whole report in Export Settings. You can then choose to exclude certain table elements from this setting by giving a different filename here in its element properties.

Worksheet Title

This setting only applies to Excel exports, as CSV files don't have sheets and only appears if the File Type is set to XLSX. 

Set a title for the Excel worksheet where this table element will be put on.
By default the worksheets are populated with the Qlik Sense object IDs of the table elements they represent. 

File Format

This setting applies to CSV exports and only appears if the File Type is set to CSV.

BOM (Byte Order Mark) is an invisible character used to indicate the encoding of a text file or stream. When a file is encoded in UTF-8 with BOM, the BOM character is placed at the beginning of the file to indicate that the file is encoded in UTF-8. This allows text editors and web browsers to correctly interpret the file as UTF-8, and display the characters correctly.

This might for example be important if your CSV export is opened in Excel (which is also an editor), to make sure all potential symbols and characters are interpreted correctly.

Field Separator

This setting applies to CSV exports and only appears if the File Type is set to CSV. 

You can choose and set a custom delimiter for your CSV data exports. It is a character which separates the columns in each data row.
The default delimiter is a semicolon ";" (set in Export Settings).

If you want to separate your data by a tabulator, just enter the word "tab" in this field.

In cases where the set delimiter is also part of the field value in your data export, this data entry will automatically be put in quotes, for example: North Area, "10,000" (the delimiter is set to comma "," but is also part of the field value "10,000")

There is also the option to set a CSV Field Separator globally for the whole report in Export Settings. You can then choose to exclude certain table elements from this global setting by setting a different delimiter here in its element properties.

Data exports only

When choosing the Export Type PDF or PPTX, the data export is being generated additionally to that, but you can also choose to only export the data from all table elements of your report where this feature is enabled by choosing the option Data export only.

1. On your Sense sheet, select the ancoreShare button for which you want to enable the data export.
2. On the properties panel, click Report Elements > Select Export Type and choose Data Exports only

Enable Download

This feature is enabled by default and only refers to the download of the generated data export files in your browser. When user clicks on the ancoreShare button and 

If this feature is disabled, the data export is still getting generated (stored in your browser session cache) and can be exported otherwise, for example via custom JavaScript API.

1. On your Sense sheet, select the ancoreShare button for which you want to enable the download of your data export.
2. On the properties panel, click Export Settings > Data Export and Enable Data Export Download

Filename (globally)

By default all data export files are named after the Qlik Sense object ID of the respective table element. This also means that by default each table element is exported in a separate Excel or CSV file, named after its ID.

The filename you set here will be applied globally to this report and when choosing the export file type XLSX all table elements will be put in one Excel file.
If there is an other filename set within the table element properties, then this table will be excluded from this file pool and exported in a separate Excel file with the given name. This here is the global setting and the table element setting will override it. 

However, when the export type is set to CSV, each table element will create a separate CSV file regardless of the filename.

Only set the custom name for the file here without the file extension (i.e. ".xlsx" or ".csv"), it will then be applied to both Excel and CSV exports.

CSV Field Separator

Set a global delimiter for CSV data exports (default is a semicolon ";"), it will then be applied to all table elements of this report, where the data export is enabled.
You can choose and set a different custom delimiter for your CSV data exports within each Table Element. This here is the global setting and the table element setting will override it.

The delimiter it is a character which separates the columns in each data row. If you want to separate your data by a tabulator, just enter the word "tab" in this field.

In cases where the set delimiter is also part of the field value in your data export, this data entry will automatically be put in quotes, for example: North Area, "10,000" (the delimiter is set to comma "," but is also part of the field value "10,000")