Qlik Community

Ask a Question

Qlik NPrinting Documents

Documents related to Qlik NPrinting.

Announcements
May 18th, Changes to the way you login: using email vs. username. READ DETAILS/WATCH VIDEO

How to Create a Simple PixelPerfect Report

Not applicable

How to Create a Simple PixelPerfect Report

Create New PixelPerfect Report

                   
            Create-New-PixelPerfect-Report.png                   
         

Run NPrinting and open the project C:\NPrintingDemo\NPrintingFiles\NPrintingTraining.nsq

  1. Click on Reports
  2. Select PixelPerfect reports
  3. Click on the PixelPerfect Report button to create a new one
  4. Enter Simple PixelPerfect Report as the report Name
       
       
       
         

Create New PixelPerfect Report Template

                   
            Create-New-PixelPerfect-Report-Template.png                   
         
  1. Click on New to open a blank template in the Template Editor
  2. Right click on the Levels node to add a level
  3. Select the Add levels option
       
       
       
         

Insert QlikView Table as Level

                   
            Insert-QlikView-Table-as-Level.png                   
         
  1. Select the Connection to the QlikView document that contains the object you want
  2. Enter '1' and '8' into the search field and the number of candidate objects is reduced to five
  3. If Top 25 Products - CH184 is the only object visible, press Enter to add it into the Levels node, otherwise select it in the list
  4. Click on the OK button
       
       
       
         

Create Level Details

                   
            Create-Level-Details.png                   
         
  1. Right click on the Detail area in the middle of the page
  2. Select Insert Detail Report
  3. Choose "CH184_Level" from the list
       
       
       
         

Create Data Columns

                   
            Create-Data-Columns.png                   
         
  1. Press SHIFT or CTRL and select the four columns of the CH184 from the Levels node
  2. Drag and drop them into the DetailReport - "CH184_Level" area
       
       
       
         

Set Column Order

                   
            Set-Column-Order.png                   
         

To change the order of the columns:

  1. Click in a cell to select it, for instance the first GP%
  2. Click on the small arrow that appears at the upper right corner, this opens the Table Cell Tasks menu
  3. Open the Data Binding drop down menu and expand the CH184_Level.GP% node
  4. Select Product Name to set this field as first column
  5. Repeat 1 through 4 for the other columns in the order Total Sales, Gross Profit and GP%
       
       
       
         

Adjust inter-Row White Space

                   
            Adjust-inter-Row-White-Space.png                   
         

To eliminate inter-row white space, select the dotted line below the table and overlap it with the bottom line of the CH184_level table.

       
       
       
         

Create Table Headings

                   
            Create-Table-Headings.png                   
         

Drag and drop the Table object from the Tool Box on the right to add column headings. Align the new table with the upper left corner of the Detail area.

       
       
       
         

Insert a Fourth Column

                   
            Insert-a-Fourth-Column.png                   
         

It is necessary to create a new column to match the data structure:

  1. Right click on the third cell
  2. Select Insert
  3. Click on Column to Left
       
       
       
         

Column Alignment

                   
            Column-Alignment.png                   
         

Select the right border of the third cell and drag it until the guideline overlaps with the right border of the third cell of the CH184_Level table. Repeat this action with the other cells until they are aligned with the corresponding cells in the CH184_Level table.

       
       
       
         

Enter Column Heading Text

                   
            Enter-Column-Heading-Text.png                   
         
  • Double click on the first column on the left to edit the text and enter Product Name
  • Repeat the process with the second column and enter Total Sales
  • Enter Gross Profit in the third cell and Gross Profit % in the last one
       
       
       
         

Table Heading Text Format

                   
            Table-Heading-Text-Format.png                   
         
  1. Select the entire table by clicking on the upper left corner
  2. Set the font type, dimension, alignment, etc. as you prefer. For instance select sans serif, 14px, Bold and Centered
       
       
       
         

Table Borders

                   
            Table-Borders.png                   
         
  1. Select the row of table headings and then find Borders in the Property Grid in the lower left corner
  2. Click on the drop down menu
  3. Click on All, and then click on the drop down button (in step 2) to accept the updated borders
       
       
       
         

Eliminate Empty Space between Headings and Data

                   
            Eliminate-Empty-Space-between-Headings-and-Data.png                   
         

Select the bottom border of the Detail area and align it with the bottom border of the table to eliminate the empty space.

       
       
       
         

Set Table Data Borders

                   
            Set-Table-Data-Borders.png                   
         
  1. Select the entire data table in the DetailReport - "CH184_Level" area
  2. Find Borders in the Property Grid
  3. Open the drop down menu
  4. Select All and the Border icons become yellow and then click the drop down button (in step 3) to accept the updated borders
       
       
       
         

Format Data Fonts

                   
            Format-Data-Fonts.png                   
         
  1. Keep the data table selected
  2. Set the font format you prefer. For instance select sans serif, 11px
       
       
       
         

Set Data Alignment

                   
            Set-Data-Alignment.png                   
         
  1. Select the ProductName cell
  2. Find "Text Alignment" in the Property Grid
  3. Click on the drop down menu
  4. Set text alignment to Middle Left
       
       
       
         

Finish Data Alignment

                   
            Finish-Data-Alignment.png                   
         
  1. Select the Total Sales cell
  2. Set text alignment to Middle Right in the Property Grid
  3. Repeat steps 1 and 2 for columns Gross Profit and Gross Profit %
       
       
       
         

Format Numbers

                   
            Format-Numbers.png                   
         

Set the number formatting to Dollar currency by:

  1. Select the cell Total Sales and click on the upper right arrow ">"
  2. Click on the dots on the right of Format String in the new window, then select Currency
  3. Click on the Custom tab
  4. Select the $0.00 format
  5. Confirm with OK.
  6. Repeat steps 1 to 5 for the Gross Profit cell
  7. Format Gross Profit % as Percent 0.00%
       
       
       
         

Save the Template

                   
            Save-the-Template.png                   
         
  1. Click on the Save As icon in the Report group of the tool bar
  2. Make sure that the Save As window is set to save in the C:\NPrintingTraining\Templates folder
  3. Enter Simple PixelPerfect Report template.npx
  4. Click on the Save button
       
       
       
         

Report Preview

                   
            Report-Preview.png                   
         

Click on the Preview icon to see the final report.

       
       
   
 
Comments
PoojaPrasad
Creator II
Creator II

How to adjust the spaces between two fields. For example, we have a column named 'first name' and another column named 'last name'. I need to adjust these columns in the report so that last name appears after a space from first name, given that first name is variable length column. 

0 Likes
Frank_S
Support
Support

@PoojaPrasad 

Drag your individual fields from your straight table (will not work with pivot table...(must use straight table with pixel perfect)

Leave space between your fields as needed. See attached.

For future reference, please ask questions directly in the NPrinting discussions page for all to see and respond to your questions going forward...thank you.

spacing in pxp editor.PNG

PoojaPrasad
Creator II
Creator II

I am doing the same. The problem arises when Product Name is short and ends early leaving a big gap between Product Name and Gross Profit values. I need just 1 space between these 2 for every level in my report. I am looking for auto adjustment of the space depending on different values of first value such that we have only 1 space between the 2 values.

0 Likes
Frank_S
Support
Support

Then I suggest to use the right align tool for your cell (left cell in the example below) so that it always end in the same position and grows out to the left.

See below...that should do it. 

right align.PNG

PoojaPrasad
Creator II
Creator II

Great. That meet the purpose. Thank you.

Frank_S
Support
Support

No worries!

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2015-04-24 03:45 AM
Updated by: