How to Use Linked Fields with Keep All Matching Values Only

    Get an understanding of the basic NPrinting Multidoc concept by executing the tutorials “How to Create a Simple Excel Report with Objects from Multiple QlikView Documents“ and "How to Use Linked Fields with Keep All Values" before starting with this one.

    Linked Fields is a new entity type that enables linking fields from more than one connected QlikView document. Each Linked Fields entity can link only one field from any connected QlikView document, but from as many as you like. When configuring a Linked Fields entity, you must specify whether you want to "Keep all values" or "Keep all matching values only". Selecting "Keep all values" causes NPrinting to create and use the union of the data sets for the fields that are linked. Selecting "Keep all matching values only" causes NPrinting to create and use the intersection of the data sets for the fields that are linked, i.e. only those values that are present in each and every linked field in the QlikView documents connected to a specific report. Linked fields can be used with Filters, Levels, Pages and Cycles.

    Clone 'All Values from Linked "Year" Fields'

                      
                Clone--All-Values-from-Linked--Year--Fields-.png                  
            
    1. Select Sources in the lower left panel
    2. Select Linked Fields in the upper left panel
    3. Select All Values from Linked "Year" Fields in the upper right panel
    4. Click on the Clone icon in the Actions group of the tool bar

    Open 'All Values from Linked "Year" Fields Copy' in Linked Fields Window

                      
                Open--All-Values-from-Linked--Year--Fields-Copy--i.png                  
            

    Double click on All Values from Linked "Year" Fields Copy to open it in the Linked Fields Editor.

        

    Edit 'All Values from Linked "Year" Fields Copy'

                      
                Edit--All-Values-from-Linked--Year--Fields-Copy-.png                  
            
    1. Change its Name to Matching Values Only from Linked "Year" Fields
    2. Change Values from Keep all values to Keep matching values only
    3. Click on the Save and Close icon in the Actions group of the tool bar
         

    Clone Excel Report

                      
                Clone-Excel-Report.png                  
            
    1. Select Reports in the lower left panel
    2. Select Excel reports in the upper left panel
    3. Select Simple MultiDoc Excel Report with Keep All Values in Linked Fields in the upper right panel
    4. Click on the Clone icon in the Actions group of the tool bar
        

    Open 'Simple MultiDoc Excel Report with Keep All Values in Linked Fields Copy' in Report Editor

                      
                Open--Simple-MultiDoc-Excel-Report-with-Keep-All-V.png                  
            

    Double click on Simple MultiDoc Excel Report with Keep All Values in Linked Fields Copy.

         

    Edit "Simple MultiDoc Excel Report with Keep All Values in Linked Fields Copy"

                      
                Edit--Simple-MultiDoc-Excel-Report-with-Keep-All-V.png                  
            
    1. Edit the Name to Simple MultiDoc Excel Report with Keep Matching Values Only in Linked Fields
    2. Adapt the Description if there is one
          

    Open Template Editor

                      
                Open-Template-Editor.png                  
            

    Click on Edit in the Template group of the tool bar.

        

    Remove 'All Values from Linked "Year" Fields' Level

                      
                Remove--All-Values-from-Linked--Year--Fields--Leve.png                  
            
    1. Right click on the All Values from Linked "Year" Fields level node
    2. Click on Remove in the pop-up menu
      

    Eliminate All 'All Values from Linked "Year" Fields' Related Tags from Template

                      
                Eliminate-All--All-Values-from-Linked--Year--Field.png                  
            

    Select the cells containing the All Values from Linked "Year" Fields tags in turn and Delete them.

        

    Add 'Matching Values Only from Linked "Year" Fields' Level

                      
                Add--Matching-Values-Only-from-Linked--Year--Field.png                  
            
    1. Enter a key word into the Search field to facilitate finding the level you want
    2. Select Matching Values Only from Linked "Year" Fields from either Connection as they are equivalent
    3. Click on the OK button
       

    Embed 'Matching Values Only from Linked "Year" Fields' Level in Template

                      
                Embed--Matching-Values-Only-from-Linked--Year--Fie.png                  
            

    Drag and drop the Matching Values Only from Linked "Year" Fields level node token into the template onto cell A2. It will expand to become two tags, one start and one end.

      

    Redefine Level Range

                      
                Redefine-Level-Range.png                  
            

    Reposition the </Matching Values Only from Linked "Year" Fields_Level> tag to cell A20, redefining the level range so that it includes both charts and their headings.

       

    Embed Heading

                      
                Embed-Heading.png                  
            
    1. Expand the Matching Values... level node by clicking on the '+' to its left
    2. Drag the Matching Values... name node into the template and drop it on cell B3
    3. Click on the Preview icon
         

    Resulting Report

                      
                Resulting-Report.png                  
            

    Inspect and admire. The report  displays charts for 2011 and 2012 because they are the only years containing data present in both connected QlikView documents.

       

    Open Save As Window

                      
                Open-Save-As-Window.png                  
            

    Click on the Save As icon

       

    Save Template

                      
                Save-Template.png                  
            
    1. Change the template Name to Simple MultiDoc Excel Report with Keep Matching Values Only in Linked Fields template.xlsx
    2. Click on the Save button
         

    Save Your Report

                      
                Save-Your-Report.png                  
            

    Click on the Save and Close icon.