topic Re: NPrinting Excel reporting with a loop on several sheet in Qlik NPrinting

NPrinting Excel reporting with a loop on several sheet

Wed, 18 Jan 2017 10:30:33 GMT

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

Re: NPrinting Excel reporting with a loop on several sheet

Stephen_Jasionowski — Wed, 18 Jan 2017 11:24:03 GMT

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

Re: NPrinting Excel reporting with a loop on several sheet

Wed, 18 Jan 2017 12:35:54 GMT

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.

Re: NPrinting Excel reporting with a loop on several sheet

Stephen_Jasionowski — Wed, 18 Jan 2017 12:40:30 GMT

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 Values