Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Nov 6, 2015 8:34:18 AM
Nov 6, 2015 8:34:18 AM
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.
Double click on All Values from Linked "Year" Fields Copy to open it in the Linked Fields Editor.
Double click on Simple MultiDoc Excel Report with Keep All Values in Linked Fields Copy.
Click on Edit in the Template group of the tool bar.
Select the cells containing the All Values from Linked "Year" Fields tags in turn and Delete them.
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.
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.
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.
Click on the Save As icon
Click on the Save and Close icon.