Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Nov 6, 2015 8:47:49 AM
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 the Select field window again then by clicking on the Add icon:
Double click on Simple MultiDoc Excel Report Copy, which you'll find at the bottom of the list, to open the Excel Report window.
Click on Edit in the Template group of the tool bar
Linked fields can be selected for:
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.
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.
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
Click on the Save As icon.
Click on the Save and Close icon.
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”.