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

How to Make a Calculated Column in Excel Reports

Not applicable

How to Make a Calculated Column in Excel Reports

When creating a template for an Excel report, you may need to create a column that combines the values of two or more other columns with or without coefficients. A third column will be obtained by subtracting the values in one column from the values in the other. Then the derived values of the third column will be divided by the corresponding values from one of the original two columns.
    
      

Add Table as Level

                
            Add-Table-as-Level.png
      
  1. Right click on the Levels node
  2. Select Add level
  3. Select one or more charts that have the fields you want to combine to create an additional field
  4. Click on OK
    
    
    
      

Embed Table Level in Template

                
            Embed-Table-Level-in-Template.png
      

Drag the chart node into the template and drop it onto the first cell of three vertically aligned empty cells.

    
    
    
      

Add Fields to Template

                
            Add-Fields-to-Template.png
      
  1. Expand the table node(s) by clicking on the '+' to the left of each
  2. Drag field nodes into the template, dropping them onto empty cells in columns that are in the same column or to the right of the column containing the level tags and in a row that is between the rows containing the level tags
    
    
    
      

Enter Formula to Be Calculated

                
            Enter-Formula-to-Be-Calculated.png
      

Enter the formula either in the cell editor at the top or directly in the cell.

    
    
    
      

Use Calculated Field as Input for Another Calculated Field

                
            Use-Calculated-Field-as-Input-for-Another-Calculat.png
      

Enter the formula either in the cell editor at the top or directly in the cell.

    
    
    
      

Add Headings to Columns

                
            Add-Headings-to-Columns.png  
      

Enter headings for each of the columns in a row one or two above the row containing the <CH184_Level> tag and format them.

    
    
    
      

View Results

                
            View-Results.png
      

I have applied conditional formatting to the last column, Saved, Closed, and Previewed.

    
    

<

Labels (1)
Version history
Revision #:
1 of 1
Last update:
‎2015-11-10 05:07 AM
Updated by: