Qlik Community

Qlik NPrinting Documents

Documents related to Qlik NPrinting.

Announcements
See why Qlik is recognized as a Leader for the 10th year in a row – and discover how Qlik can help put your business in the lead. Get Report

Selected QlikView Cell Values Used in Excel Reports

Not applicable

Selected QlikView Cell Values Used in Excel Reports

   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
     
     
 
Labels (1)
Version history
Revision #:
1 of 1
Last update:
‎2015-11-10 06:51 AM
Updated by: