Selected QlikView Cell Values Used in Excel Reports

Created by Maria Mårtensson on Nov 10, 2015 6:51 AM. Last modified by Björn Wedbratt on Nov 16, 2015 7:48 AM.
Version 1
       Use any cell value or group of cell values from QlikView objects in your Excel reports.
     
     
         
           

    Create New Excel Report

                     
                Create-New-Excel-Report.png
           
    1. Select Reports
    2. Select Excel reports
    3. Click on Excel Report
         
         
         
           

    Create New Template

                     
             
           
    1. Enter a meaningful Name for the report
    2. Select New in the Template section of the menu             
         
           

    Open Add Cells Window                 

                Open-Add-Cells-Window.png
           
    1. Right click on the Cells node
    2. Click on Add cells
         
         
         
           

    Open Select Object Window

                     
                Open-Select-Object-Window.png
           

    Select the browse icon to the right of the Object field.

         
         
         
           

    Select Object to Import                 

                Select-Object-to-Import.png       
           
    1. Select a Connection to the QlikView document containing the object you want to add, in this case, SalesDemo
    2. Select the Top 25 Products - CH184 object
    3. Click on OK
         
         
         
           

    Specify Cell

                     
                Specify-Cell.png
           
    1. Enter the number one in the Top Row field. Notice that the Bottom Row field also contains the number one now. The fact that they contain the same number means that you are selecting cells from only one row.
    2. Enter the number one in the Left Column field. You will notice that the Right Column field also contains the number one now. The fact that they contain the same number means that you are selecting cells from only one column.
    3. The Keep Source Formats box is checked by default. Leave it so.
    4. Click on OK
                
         
           

    Select Same Cell to Import

                     
                Select-Same-Cell-to-Import.png 
           

    Repeat the three previous steps again but uncheck the Keep Source Formats box this time.            

         
           

    Select Same Cell to Import Twice Again                 

                Select-Same-Cell-to-Import-Twice-Again.png      
           

    Repeat the previous step again but add the format code "$ #,##0.00" to the Format field this time. Then do it once more, but leave out the Format code because we are going to apply Excel format tools to the cell containing this last imported cell value.            

         
           

    Embed Cell Values in Template                 

                Embed-Cell-Values-in-Template.png                 
           
    1. Drag the cell value node tokens into the template and drop them on an empty cell one at a time
    2. Format the cell containing Top 25 Products_1_1_3 with Excel formatting tools
    3. Click on Preview
         
         
         
           

    Inspect Results

                     
                Inspect-Results.png
         
         
         
           

    Select the QlikView Object                 

                Select-the-QlikView-Object.png
         
         
         
           

    Select New Source Object to Import Cells from                 

                Select-New-Source-Object-to-Import-Cells-from-.png
           

    Switch to another Worksheet

    1. Chose the Product KPI - CH189 object
    2. Enter the number zero in the Top Row field
    3. Enter the number five in the Bottom Row field. This combination selects cells from rows zero (row 0 is the heading row) through row five
    4. Enter the number zero in the Left Column field
    5. Enter the number one in the Right Column field. This combination selects cells from the first two columns in the chart
    6. Uncheck the Keep Source Formats box
    7. Click on OK
         
         
         
           

    Build Table

                     
                Build-Table.png
           

    Drag each of the Cell node tokens into the template and drop them onto appropriate empty cells one by one. Note the progression of indices. Format to please. The last few cells have been embedded and formatted outside the scheme to show that they can be placed and formatted independently.            

         
           

    Results from Build Table Template                 

                Results-from-Build-Table-Template.png