You need to download and install the following before starting this tutorial :
You'll learn in this tutorial how to send On-Demand reports that have been filtered dynamically by filters that the user has set specifically for this distribution. The suggested architecture has two .qvw's, one as GUI (Graphic User Interface) published on the QlikView server or opened by users locally on a QlikView Desktop, and one with data and charts used by NPrinting reports. You can, of course, use a single .qvw, but it is recommended to separate GUI from data. When we speak about current selections, we mean the filters applied by the final user on the .qvw providing the graphic interface. Add List Boxes to QlikView documents so users will be able to set filters and then request filtered reports. Please note that NPrinting filters, those saved in NPrinting Project files, have higher priority than Additional Filters added through current selections. This means:
Open the QlikView document C:\NPrintingTraining\QlikViewDocuments\SalesDemo for Ajax.qvw and add a new NPrinting Report Extension, see: How to Use NPrinting Extensions in Qlikview Documents.
Button color: it’s the color of the button in HTML format. Insert the QlikView formula =rgb(66,80,80) to convert an RGB sequence into an HTML color code.
Check that the parameters are as below, or adjust them for your special circumstances:
Set as follows:
Drag and drop the List Box icon onto the sheet and edit the resulting list box so that its field is Year.
Drag and drop the List Box icon onto the sheet and edit the resulting list box so that its field is CategoryName.
Drag and drop the List Box icon onto the sheet one more time and edit the resulting list box so that its field is Country.
Click on the 3.5" floppy disk icon to save the entire QlikView document.
Make some selections in the list boxes. Select Year=2012 and Country=France for instance, then request generation of the PowerPoint Report with Multiple Pages - Current Selections report. Please ignore the Interactive Services Detections message if it appears and wait until the NPrinting Queue button shows that the report is ready.
Trick: open the Windows task manager performance tab: keeping under control the CPU usage you’ll see that your PC is working.
Click on the NPrinting Queue button and open the report: it will have 2 pages as can be seen above, a cover, a report for France in 2012. NPrinting has applied the filters you selected in the QlikView document.
Keep the same selections in the list boxes: Year=2012 and Country=France and request generation of the PowerPoint Report with Multiple Pages report.
The report has 7 pages as can be seen above, a cover and two reports for Germany, the UK and the USA each, one for both 2012 and 2013. NPrinting applied the filters in the report in the .nsq file and ignored your current selections. If you set a current selection on fields already used in NPrinting filters these have an highest priority and the current selection on the same fields are ignored
Clear the selections in the Year and Country list boxes and select Babywear in the CategoryName list box. Now request generation of the PowerPoint Report with Multiple Pages report.
The report will have 7 pages as can be seen above, the cover and 2 slides each for Germany, the UK and the USA, one for 2012 and one for 2013, having sales figures only for the category Babywear. The current selection was set on a field different from those having NPrinting filters applied to them, so all filters have their effect.
We suggest that you do How to Use Specific Filters with NPrinting On-Demand Reporting now that you have completed this tutorial.