Qlik Community

Qlik NPrinting Documents

Documents related to Qlik NPrinting.

How to Use Pages to Generate Individual Slides in PowerPoint for Each Combination of Multiple Field Values

Employee
Employee

How to Use Pages to Generate Individual Slides in PowerPoint for Each Combination of Multiple Field Values

Create a slide for every combination of values from two or more fields. The employ of two fields is illustrated here. You can also customize the final order of produced slides. There is some preliminary work that must be done in QlikView and then the creation of a PowerPoint report template is carried out.

    
    
        
          

Part I: Prepare Table Box in QlikView

        
        
        
          

Open QlikView Document in QlikView

                    
            Open-QlikView-Document-in-QlikView.png                    
          

Open SalesDemo.qvw in QlikView.

  1. Select the QlikView sheet where you might want the new object to appear and right click any empty part of the sheet
  2. Select New Sheet Object
  3. Click on Table Box...
        
        
        
          

Create Table Box

                    
            Create-Table-Box.png                    
          
  1. Select the fields of interest from the list of Available Fields. For instance "Country" and "Year"
  2. Click on the Add button so that the chosen fields get transferred to the Fields Displayed in Tablebox list
  3. Click on the OK button at the bottom of the New Table Box window
        
        
        
          

Optional: Customize the Sort Order

                    
            Optional--Customize-the-Sort-Order.png                    
          

You can customize the sort order of slides in the final PowerPoint report by setting the sort order in the original QlikView object. This step is optional, you can skip it if you want to keep the original order of the slides.

        
        
        
          

Part II: Create PowerPoint Report

        
        
        
          

Create New Template

                    
            Create-New-Template.png                    
          

Create a new report and open the Template Editor

  1. Right click on the Page node
  2. Click on the Add page to current sheet pop-up button
        
        
        
          

Select Field Table for Page

                    
            Select-Field-Table-for-Page.png                    
          
  1. Select the Connection with the QlikView document that contains the Table Box object that has been prepared
  2. Select Table for Field Combination Pages in NPrinting - TB04 in the Select Page list
  3. Click on the OK button
        
        
        
          

Create Slide Heading

                    
            Create-Slide-Heading.png                    
          
  1. Expand TB04_Page - Table for Field Combination Pages in NPrinting node
  2. Compose the slide heading, dragging the Country and Year node tokens and dropping them in the appropriate positions
        
        
        
          

Add Chart Object as Image

                    
            Add-Chart-Object-as-Image.png                    
          
  1. Add Sales by Category -  CH311 to the Images node
  2. Drag the CH311 - Sales by Category node token into the template and drop it onto the slide
        
        
        
          

Preview Report

                    
            Preview-Report.png                    
          

Inspect slide 49.

        
        
    
  
Labels (1)
Comments
agni_gold
Valued Contributor II

Hi friends ,

I am facing issue with current selection box in nprinting report, i have created formula in nsq file as getcurrentselection function and added to nprinting report , so only year and month are coming but other field selection are not coming , please help me why other filed are not coming in my current selection .

I have checked in my template also , in my PPT template there are two slides , but when i am trying current selection formula at first slide it is working. But when using in second slide it is only showing year and month selection in as current selection not other fields.

Version history
Revision #:
1 of 1
Last update:
‎11-10-2015 07:00 AM
Updated by: