Exporting is key for many businesses, and at Vizlib, we know this. We provide five (5) simple but crucial exporting methods.

See examples of the exported data at the bottom of the page.

TABLE OF CONTENTS

• Export Actions
  • Export Data
  • Export Object Data
  • Export Object PDF
  • Export Object Image
  • Export Sheet to PDF

Export Actions

Export Data

Export Data allows you, the developer, to define specific Dimensions and Measures to be exported. You can also choose to make these dynamic by using Variables.

This data must be within the Qlik App you are developing within. You cannot reference other data from another App using this method.

Figure 1.1: Vizlib Action | Export Data property panel

Dimension Fields

• The Dimensions you want to export within the file. These need to be separated via a 'pipe' [ | ].
• The expected result can look like, ='Country|State|Product', or if you have special characters within the field names, ='[Grouped Countries]|[#Ranked States]|[Branded Products]'.

Measure Expressions

• The Measures you want to export within the file. These need to be separated via a 'pipe' [ | ].
• The expected result can look like, ='Sum(Sales)|Avg(Margin)' or if you have special characters within the field names ='Sum([Sales by top Agents)]|Avg([%of Margin])'.

File Name

• The file name is a simple string of text or characters

Export Format

• You can export to:
  • Excel
  • CSV
  • TSV

Export State

• You can choose between 2 options:
  • All Values
  • Possible Values

Figure 1.2: Vizlib Action | Export Data

Export Object Data

Export objects to Data only work with Master Items that you have created/added. To export an object's (A.K.A visualisation) data, select from the options in the property panel and then click on the Vizlib Button when in analysis mode.

You can reference any Master Item Visualization within the Qlik App. It does not have to be a chart that is on the page.

Figure 2.1: Vizlib Action | Export Object Data property panel

Pick Export Item

• When exporting using the Vizlib Button, you must choose a Master Item Visualization.

File Name

• The file name is a simple string of text or characters

Export Format

• You can export to:
  • Excel
  • CSV
  • TSV

Figure 2.2: Vizlib Action | Export Object Data

Export Object PDF

Export objects to PDF only work with Master Items you have created/added. To export an object's (A.K.A visualisation) data, select from the options in the property panel and then click on the Vizlib Button when in analysis mode.

You can reference any Master Item Visualization within the Qlik App. It does not have to be a chart that is on the page.

Figure 3.1: Vizlib Action | Export Object PDF property panel

Pick Export Item

• When exporting using the Vizlib Button you must choose a Master Item Visualization.

Document Size

• The paper sizes you can choose from are:
  • A3 - Largest
  • A4
  • A5
  • A6
  • A7 - Smallest
• Here is an external link to Wikipedia if you need help understanding paper sizes.

Orientation

• The two choices are:
  • Landscape
    • Where the width of the page is longer than the height.
  • Portrait
    • Where the height of the page is longer than the width.

Aspect Ratio

• The two choices are:
  • Fit To Page
    • Will fit the object you are exporting to best fit the page size and orientation.
  • Custom
    • You can define the Width and Height of the object on the page.

File Name

• The file name is a simple string of text or characters

Figure 3.2: Vizlib Action | Export Object PDF

Export Object Image

Export objects to Data only work with Master Items that you have created/added. To export an object's (A.K.A visualisation) data, select from the options in the property panel and then click on the Vizlib Button when in analysis mode.

You can reference any Master Item Visualization within the Qlik App. It does not have to be a chart that is on the page.

Figure 4.1: Vizlib Action | Export Object Image property panel

Pick Export Item

• When exporting using the Vizlib Button, you must choose a Master Item Visualization.

Format

• The two choices are:
  • JPEG
  • PNG

Width

• Define the pixel width of the visualization

Height

• Define the pixel height of the visualization

File Name

• The file name is a simple string of text or characters

Figure 4.2: Vizlib Action | Export Object Image

Export Sheet to PDF

Export Sheet to PDF is a simple method to export the current Qlik Sheet page to a PDF. The page will be rendered and then presented to the user based on the requirements set out in the property panel.

Figure 5.1: Vizlib Action | Export Sheet to PDF property panel

Document Size

• The paper sizes you can choose from are:
  • A3 - Largest
  • A4
  • A5
  • A6
  • A7 - Smallest
• Here is an external link to Wikipedia if you need help understanding paper sizes.

Orientation

• The two choices are:
  • Landscape
    • Where the width of the page is longer than the height.
  • Portrait
    • Where the height of the page is longer than the width.

Aspect Ratio

• The two choices are:
  • Fit To Page
    • Will fit the object you are exporting to best fit the page size and orientation.
  • Custom
    • You can define the Width and Height of the object on the page.

File Name

• The file name is a simple string of text or characters

Figure 5.2: Vizlib Action | Export Sheet to PDF