Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Riccardo_1
Contributor II
Contributor II

How to use Cycle to sheets in Excel document in Qlik Nprinting?

Hello,

We use Qlik Qlik NPrinting  May 2021 SR1

Is it possible to cycle through a dimension and export each cycle to a new Excel sheet in one document?

For example; 

SalesPerson A  has in his SalesPersonCountries 3 countries configured: DE, FR, ES

AND SalesPerson B has only 1 country configured: IT

Is it possible to create a task where SalesPerson A retrieve one Excel Document with 3 Sheets: DE, FR and ES

and salesPerson B retrieve one Excel document with 1 sheet: IT

 

Is something like this possible?

Kind regards,

 

Labels (2)
1 Solution

Accepted Solutions
Frank_S
Support
Support

@Riccardo_1

 

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

  • NPrinting User filters
  • NPrinting Designer Page feature

NP User filters:

  • Create a three-country filter for user A using DE, FR, ES:  SalesPerson A  has in his SalesPersonCountries 3 countries configured: DE, FR, ES
  • Add this 3-country filter to user A in the NP web console Admin>Users>User filters
  • Create a single country filter for user B using IT: SalesPerson B has only 1 country configured: IT
  • Add this single country filter to user B in the NP web console Admin>Users>User filters

Setting user filters

Creating a static filter

 

NPrinting Designer Page feature

  • Open the NP designer
  • Add the 'country' dimension to the 'Page' component

Applying Pages

 

Last,

Add user A and user B to your distribution task

Creating publish tasks

 

This should result in:

  • User A received an xlsx that contains 3 sheets: one sheet per country ie: DE, FR, ES
  • User B received an xlsx that contains 1 sheet: one sheet ie: IT

 

If I have understood your requirement hopefully this will help you.

Kind regards...

 

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

8 Replies
Lucas_Gatling
Support
Support

You be able to accomplish this by using the level functionality when creating NPrinting report. See the below link.

 

How to Add Levels in Excel Reports

If the issue is solved please mark the answer with Accept as Solution.
Riccardo_1
Contributor II
Contributor II
Author

Hello Lucas,

Thank you so much for your time. Much appreciated!

 

The level does the cycle in one Excel sheet.

I am searching for a solution that each cycle add a new Excel sheet. Do you know if this is possible?

 

Thanks again.

 

Frank_S
Support
Support

@Riccardo_1

 

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

  • NPrinting User filters
  • NPrinting Designer Page feature

NP User filters:

  • Create a three-country filter for user A using DE, FR, ES:  SalesPerson A  has in his SalesPersonCountries 3 countries configured: DE, FR, ES
  • Add this 3-country filter to user A in the NP web console Admin>Users>User filters
  • Create a single country filter for user B using IT: SalesPerson B has only 1 country configured: IT
  • Add this single country filter to user B in the NP web console Admin>Users>User filters

Setting user filters

Creating a static filter

 

NPrinting Designer Page feature

  • Open the NP designer
  • Add the 'country' dimension to the 'Page' component

Applying Pages

 

Last,

Add user A and user B to your distribution task

Creating publish tasks

 

This should result in:

  • User A received an xlsx that contains 3 sheets: one sheet per country ie: DE, FR, ES
  • User B received an xlsx that contains 1 sheet: one sheet ie: IT

 

If I have understood your requirement hopefully this will help you.

Kind regards...

 

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Riccardo_1
Contributor II
Contributor II
Author

Hello Frank_S,

Thank you so much for your help and step-by-step guide with reference to the nPrinting help. This is a great help, really appreciate your time and guide.

I am implementing the steps today and will let you know the results.

Many thanks

Kind regards

 

Frank_S
Support
Support

No Worries @Riccardo_1

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Riccardo_1
Contributor II
Contributor II
Author

Hello Frank_S,

Your solution works perfect and does exactly what we need!

You saved me a bunch of time and I learned some good functionality of nPrinting.

Thank you for your help and time !!

I cannot accept your solution anymore, because some did already accept as solution. 

Kind regards

 

Frank_S
Support
Support

Hi @Riccardo_1 
I sincerely appreciate your enthusiastic reply! I am very pleased the solution is working for you.

Cheers!

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Frank_S
Support
Support

New Article: Qlik NPrinting Multi Sheet Excel Report

 

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!