NPrinting Excel Level sheets

[QlikCommSa]

Hi,

I thought that my problem can be solved pretty fast by googleing it. But I can't find a solution. 

I have different branches in my company that should only receive their data and I have administration employees that should receive data for every branch. My problem is, that these administration employees don't want to have the data in one excel sheet, but in one sheet per branch. 

How can I loop through my branches and create different sheets in NPrinting Excel?

Thanks in advance for your help!

[Lech_Miszkiewicz · Accepted solution]

Hi @QlikCommSa 

indeed it is rather simple requirement and can be easily achieved. 

• You need to use Page tag in your report design in order to setup each sheet for separate branch: https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/ExcelReports/Create-Excel-Reports.ht...

Report distribution and „who can see what” is achieved by applying user filters. 

[QlikCommSa]

Perfect! Thanks a lot!!