Qlik Community

Qlik NPrinting Documents

Documents related to Qlik NPrinting.

How to Export QlikView Objects to CSV files

Not applicable

How to Export QlikView Objects to CSV files

QlikView Entities based on the Object types: TableBox, PivotTable, StraightTableBox, and Chart can be exported to Comma-Separated-Values (CSV) files. QlikView Reports cannot be exported to CSV files for the moment.

Be aware that files containing many records can become very large and unmanageable.

If you would like to change the separator character when you export QlikView objects to CSV files, see: How to Customize the Separator Character When Exporting QlikView Objects to CSV Files

Previewing in CSV format is also featured.

If you want to insert more than one table in a single CSV file you have to create a PixelPerfect report and export it in CSV format.

 
 
     
       

Create New QlikView Entity Report

                 
            Create-New-QlikView-Entity-Report.png                 
       
  1. Select the Reports icon in the lower left pane
  2. Select the QlikView Entity reports icon in the upper left pane
  3. Click on the QlikView Entity Report icon in the New group
     
     
     
       

Set QlikView Entity Report Parameters

                 
            Set-QlikView-Entity-Report-Parameters.png                 
       
  1. Enter Export a QlikView Object to a CSV file in the Name field
  2. Enter an explanatory Description (optional)
  3. Open the Object Selection window by clicking on the browse button at the extreme right end of the Object ID field
     
     
     
       

Select Object

                 
            Select-Object.png                 
       
  1. Select the Top 25 Products - CH184 object by clicking on it
  2. Click on the OK button
     
     
     
       

Conclude Report Preparation

                 
            Conclude-Report-Preparation.png                 
       
  1. Change the Output File: File Name to Top_25_Products. Be sure to be compliant with the Windows file names conventions.
  2. Click on Save and Close
     
     
     
       

Create Task

                 
            Create-Task.png                 
       
  1. Select the Tasks icon in the lower left pane
  2. Select the Report Tasks icon in the upper left pane
  3. Click on the Report Task icon to open the Report Task window
     
     
     
       

Set Task Parameters

                 
            Set-Task-Parameters.png                 
       
  1. Enter Export a QlikView Object to a CSV file as the Name for your Report Task
  2. Enter an explanatory Description (optional)
  3. Set the Output Folder name to: C:\NPrintingTraining\Output\
     
     
     
       

Add Report to Task

                 
            Add-Report-to-Task.png                 
       
  1. Click on the Add icon in the Report group
  2. Select the Export a QlikView Object to a CSV file report from the list in the Select Reports dialog window
  3. Click on the OK button
     
     
     
       

Set Output Format

                 
            Set-Output-Format.png                 
       
  1. Open the Output Format drop-down menu by clicking on the cell containing Pdf
  2. Select Csv for the Output Format

If you would like to change the separator character when you export QlikView objects to CSV files, see: "How to Customize the Separator Character When Exporting QlikView Objects to CSV Files"

     
     
     
       

Conclude Task Preparation

                 
            Conclude-Task-Preparation.png                 
       

Click on Save and Close to save the task and prepare to run it.

     
     
     
       

Run Task

                 
            Run-Task.png                 
       
  1. Select the Export a QlikView Object to a CSV file task
  2. Run the Task by clicking on the Run icon in the Task group
     
     
     
       

Check Log

                 
            Check-Log.png                 
     
     
     
       

Check for CSV File

                 
            Check-for-CSV-File.png                 
       

Jump for Joy!

     
     
 
Version history
Revision #:
1 of 1
Last update:
‎04-23-2015 06:26 AM
Updated by: