article Qlik NPrinting Multi Sheet Excel Report in Official Support Articles

Qlik NPrinting Multi Sheet Excel Report

Frank_S — Wed, 16 Feb 2022 10:52:46 GMT

To accomplish this, you will need to utilize two features:

Qlik NPrinting User filters
Qlik NPrinting Designer Page feature

Qlik NPrinting User filters (with "Country" dimension example. You may use any dimension which you prefer of course):

Create a three country filter for user A using Germany, France, Spain:
Add this 3 country filter to user A to in the NP web console Admin>Users>User filters
Create a single country filter for user B using Italy
Add this single country filter to user B in the NP web console Admin>Users>User filters
See Configuring report distribution.
and Examples of filtering results.

NPrinting Designer Page feature:

Open the NP designer
Add the 'Country' dimension to the 'Page' component
See Adding a table column by column.

Finally:

Add user A and user B to your NPrinting distribution Publish Task
See Creating publish tasks.

This results in:

User A receiving an xlsx that contains 3 sheets: one sheet per country ie: Germany, France, Spain
User B receiving an xlsx that contains 1 sheets: one sheet ie: Italy

Related Content

Discussion: Cycle to sheets in Excel document

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

Environment