Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP

How to Use Linked Fields with Keep All Values

cancel
Showing results for 
Search instead for 
Did you mean: 
Stefano_Dalla_Guarda

How to Use Linked Fields with Keep All Values

Last Update:

Nov 6, 2015 8:47:49 AM

Updated By:

Stefano_Dalla_Guarda

Created date:

Nov 6, 2015 8:47:49 AM

Get an understanding of the basic NPrinting Multidoc concept by executing the tutorial “How to Create a Simple Excel Report with Objects from Multiple QlikView Documents“ 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.

  

Open New Linked Fields Window

                 
            Open-New-Linked-Fields-Window.png                 
       
  1. Select Sources in the lower left pane
  2. Select Linked Fields in the upper left pane
  3. Click on the Linked Fields icon in the New group
   

Give Identity to LinkedFields Object

                 
            Give-Identity-to-LinkedFields-Object.png                 
       
  1. Enter All Values from Linked "Year" Fields for your LinkedFields object Name
  2. Enter a Description (optional)
  3. Click on the Add icon
     

Add One or More Fields from First Connection

                 
            Add-One-or-More-Fields-from-First-Connection.png                 
       
  1. Select SalesDemo as the Connection if it is not already selected, it may take a minute for QlikView to load the document and transmit to this window
  2. Enter a key word to facilitate finding the field you want, Year in this case
  3. Select the Year field
  4. Click on the OK button
 

Add One or More Fields from Another Connection

                 
            Add-One-or-More-Fields-from-Another-Connection.png                 
       

Open the Select field window again then by clicking on the Add icon:

  1. Select Sales Compass as the Connection, the list may take some time to appear if this is the first use of this connection and the document is large.
  2. Enter key words to facilitate finding the field you want, Opp Close Year in this case
  3. Select the Opp Close Year field
  4. Click on the OK button
  

Save Your LinkedFields Object

                 
            Save-Your-LinkedFields-Object.png                 
       
  1. Make sure that Keep all values has been selected for Values. This will form the union of the data sets in these linked fields
  2. Click on the Save and Close icon

Select and Clone Excel Report

                 
            Select-and-Clone-Excel-Report.png                 
       
  1. Select Reports in the lower left pane
  2. Select Excel reports in the upper left pane
  3. Click on the Clone icon
  

Open "Simple MultiDoc Excel Report" Clone

                 
            Open--Simple-MultiDoc-Excel-Report--Clone.png                 
       

Double click on Simple MultiDoc Excel Report Copy, which you'll find at the bottom of the list, to open the Excel Report window.

Re-Identify Report

                 
            Re-Identify-Report.png                 
       
  1. Add "with Keep All Values in Linked Fields" to the Name
  2. Adapt the Description if there is one

Open Report in Template Editor

                 
            Open-Report-in-Template-Editor.png                 
       

Click on Edit in the Template group of the tool bar

 

Add Level to Template

                 
            Add-Level-to-Template.png                 
       
  1. Open the Select Levels window by right clicking on the Levels node and clicking on the Add levels button (see: )
  2. Select either of the All Values from Linked "Year" Fields. They are equivalent since they are linked.
  3. Click on the OK button

Linked fields can be selected for:

  • Cycles
  • Levels
  • Pages
  • Filters
 

Embed 'All Values from Linked "Year" Fields' Level in Template

                 
            Embed--All-Values-from-Linked--Year--Fields--Level.png                 
       

Drag and drop the All Values 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 </All Values 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 All Values... level node by clicking on the '+' to its left
  2. Drag the All Values... name node into the template and drop it on cell B4
  3. Click on the Preview icon

Inspect MultiDoc Report

                 
            Inspect-MultiDoc-Report.png                 
       

The report displays charts from 2009 to 2013. These years are in at least one of the two connected QlikView documents. An empty chart means that the associated connected QlikView document has no data for the selected year

   

Save Your Template

                 
            Save-Your-Template.png                 
       

Click on the Save As icon.

    

Rename and Save

                 
            Rename-and-Save.png                 
       
  1. Make sure you are saving to C:\NPrintingTraining\Templates
  2. Rename the template to Simple MultiDoc Excel Report with Keep All Values in Linked Fields template.xlsx
  3. Click on the Save button
    

Close Template Editor

                 
            Close-Template-Editor.png                 
       

Click on the Save and Close icon.

 

Save Your MultiDoc Report

                 
            Save-Your-MultiDoc-Report.png                 
       

Click on the Save and Close icon to save your Excel MultiDoc report.

Now we suggest that you execute the third tutorial of this series, “How to Use Linked Fields with Keep All Matching Values Only”, to see the difference between the options “Keep all values” and “Keep matching values only”.

Labels (1)
Version history
Last update:
‎2015-11-06 08:47 AM
Updated by: