topic NPrinting Excel Level sheets in Qlik NPrinting

NPrinting Excel Level sheets

QlikCommSa — Wed, 14 Feb 2024 08:54:45 GMT

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!

Re: NPrinting Excel Level sheets

Lech_Miszkiewicz — Wed, 14 Feb 2024 09:05:49 GMT

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.htm#anchor-7

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

Re: NPrinting Excel Level sheets

QlikCommSa — Wed, 14 Feb 2024 09:34:15 GMT

Perfect! Thanks a lot!!