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!