Exporting data from a visualization

You can export data from a visualization to Excel and save it in an .xlsx file.

Do the following:

1. Long-touch/right-click the visualization that you want to export data from.

2. Select I Export data.

3. In the Export complete dialog, click the link to download the data file.

4. Open or save the file.

The data has been exported to an .xlsx file.

Qlik Sense always tries to export data in number format if possible. Therefore if a number or a string is preceded by zeros, these zeros values are not exported to Excel. Example: 02 is exported to 2.

When you export tables from Qlik Sense, the resulting .xlsx files will have dimensions before measures, regardless of the order in the Qlik Sense table visualization. This is due to how the Qlik Sense Engine Service associates data. To work around this current limitation, create calculated dimensions from your measures and use the dimensions instead of measures in the table.

Limitations

There are limitations to the amount of data that can be exported. You can reduce the data amount by making selections. Excluded values are not exported.

Exporting data is currently not supported for the following:

• Treemap
• Pivot table
• Bar chart (stacked, with two dimensions)
• Line chart (with two dimensions)