Vizlib Home Try Vizlib
Welcome
Login

Exporting a Vizlib Pivot Table from Qlik Sense


Vizlib Pivot Table exports from Qlik Sense 


Role permissions to set the export type


You must have a Designer role to set the export type in Qlik Sense and Qlik SaaS. Users cannot change how their data are exported when clicking on the 'Export to Excel icon'.


Limitations


When exporting Table data to XLS/CSV etc., the totals won't be included in the exported file. This is a Qlik limitation. Please see our article on Vizlib Table data good practice and troubleshooting for more information.



TABLE OF CONTENTS



Understanding format processing performance - server or browser


Beside each export type on this page, we've included whether the export is rendered or processed on your Qlik server or in your web browser. 


This is important to understand because if you select Formatted Export which is processed by your browser, then: 

  • The efficiency of the export relies on your computer and browser processing speed.
  • All formatting elements (spacing, colors, font details, etc.) must be processed, which can also slow down the export performance.
  • Formatting issues may occur if the browser's export functionality doesn't support your chosen formatting.


Therefore if you’re in a rush, please use an option that exports using your Qlik Server. 


Please note: the Qlik Sense API / engine drives the export type, not Vizlib. 


If you need help, please get in touch with our Support team at support@vizlib.com and include the browser type you're using.


Export from Qlik Sense - download options



1. Right-click or move your mouse over your pivot table to view the option to view the table full screen and the context menu (...).

Figure 1: Context menu
2. Click the context menu (...) to view the option to Download as….

Figure 2: Select 'Download as...'

3. Pivot Table download types from the context menu include:
  • Image: (Server rendering) Renders a PNG image of the chart
  • PDF: (Server rendering) Renders an image of the chart in a PDF
  • Export Formatted Data to Excel: (Browser export) Exports a formatted Pivot Table to Excel.
  • Fast export straight table to Excel: (Server export) Exports an unformatted Straight Table to Excel.
  • Fast export pivot table to Excel: (Server export) Exports a formatted Pivot Table to Excel.
  • Fast export straight table to CSV: (Server export) Exports a straight table CSV.
  • Fast export straight table to TSV: (Server export) Exports a straight table TSV.

Figure 3: Export options
4. The message 'Your exported data is ready for download' displays. Click the link to download your file. Figure 4: Download your data file




Formatted Exports - Values or Text export


The default - formatted export - treats all cell data as ‘values’ (text strings)- for example, a hyperlink in your data will export as a link). 

  • Values export - looks at the underlying data, including expressions.
  • Text export - displays the data.



Figure 5: Values Export or Text Export Examples


Pivot Table exports using the Quick Export icon


The Vizlib Pivot table supports three fast export options by clicking the Excel icon visible on the top-right of the Pivot table. 


Figure 6: Quick Export options


  • Formatted export: (Browser export) - Exports the Pivot Table with formatting applied.
  • Straight table: (Server export) - Exports your data unformatted. Downloaded as a straight table.
  • Pivot table:(Server export) - Exports an unformatted Pivot Table.


Please note: Qlik Sense API / engine drives the export type, not Vizlib.


Excluding selections and titles


By default, the option 'Include selections & titles' is selected. This option adds the Header, Subtitle, and/or Footer data. 

Deselect the box if you don't want to include titles in your export.


Examples of Pivot Table Quick exports


Figure 7: Example of the differences between Formatted export, Straight table, and Pivot table. 

Amending Export permissions


In the Qlik Sense Security Rules, you can amend and restrict export permissions; however, in our Vizlib extension, the Quick Export icon can only be disabled using the Interactivity section in the Property Panel.  


Click on your table, and scroll down to the section Interactivity.

In the section Pivot Header Actions, move the slider to the right (the 'on' position) for the section Show Export Button Icon.


Figure 8: Show or Hide the Export button icon.




Back to Contents



V
Vizlib is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.