Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

NPrinting Excel reporting with a loop on several sheet

NPrinting Excel reporting with a loop on several sheet. Cyclic grouping in NPrinting will give one report per Country, but I want only one report with all countries . Read on community that its possible with  link filter option. What is link filter option and to do this. Below is the post .

NPrinting Excel reporting with a loop on severa... | Qlik Community

1 Solution

Accepted Solutions
3 Replies
Stephen_Jasionowski

Jyoti - you want to use the page function with the Country field. See the following: How to Use the Page Feature in Excel and PowerPoint Report Templates

Not applicable
Author

If I have to create page on multiple dimensions like country and team . So my data is like I will show the data on country level and then for each country on team level.

example - sheet for all country say Germany , France ,UK etc.

then sheet for all teams in Germany (Team A ,Team B ) , France (Team C ,Team D, Team E ,Team F ),UK  (Team I ,Team J, Team K  ,Team L) in same PPT.

Can I have all in one ppt.

Stephen_Jasionowski

Yes, with PowerPoint you can cycle thru multiple dimensions on each slide: How to Use Pages to Generate Individual Slides in PowerPoint for Each Combination of Multiple Field ...