QlikView NPrinting allows you to add paging to a particular Excel sheet. How to Use the Page Feature in Excel and PowerPoint Report Templates
Lets say you have a table containing Regions, Countries & Population. You could place a chart containing all details on Sheet1, place another instance of the same chart (or another appropriate chart) on Sheet2 and page by Country only on Sheet2.
I have attached a project that demonstrates this. If your On-demand user selects Region NORTHERN AMERICA & clicks Run report
You can of course do something similar with Levels if you want everything on one sheet.
Extract to folder C:\Temp\Community\036 to preserver the paths used or change them in the nsq.
HTH - Daniel.
036.zip 359.2 K