topic Re: How do I remove specific tabs in excel report in Qlik NPrinting

How do I remove specific tabs in excel report

Wed, 23 Aug 2017 16:04:48 GMT

I have a report I am creating that gives a summary overview of profit and loss for my company. what i am trying to do is have 1 tab be the overall summary but the other tabs break down the summary by business unit. there are 2 business units I don't want tabs for. I tried to create a filter for those 2 units, but it also took the information out of the main summary report on the first tab. what can I do to be able to just get rid of those tabs only?

Re: How do I remove specific tabs in excel report

devarasu07 — Wed, 23 Aug 2017 16:54:04 GMT

Hi,

Try to remove that page from your nprinting excel

for more check this article

How to Use the Page Feature in Excel and PowerPoint Report Templates

NPrinting Features for Creating Excel Reports

Re: How do I remove specific tabs in excel report

Wed, 23 Aug 2017 17:05:28 GMT

That does not help, I don't want to remove the sheet entirely, just 2 of the iterations of that sheet, specifically the intercompany and staff outputs. the other outputs I want to be visible

Re: How do I remove specific tabs in excel report

Wed, 23 Aug 2017 17:14:03 GMT

to better clarify, right now I have a spreadsheet that has tabs like this

and all I am wanting to do is to remove the staff and intercompany tabs, which are values in the BUS_UNIT field I am using to create this spreadsheet

Re: How do I remove specific tabs in excel report

devarasu07 — Wed, 23 Aug 2017 17:27:54 GMT

Hi,

Try to create Nprint filter for your business unit to exclude those two values from spread sheet

create filter for Business Unit and select these two values (intercompany and staff outputs) then enable check box for select excluded.

Re: How do I remove specific tabs in excel report

Wed, 23 Aug 2017 17:56:03 GMT

I did try to create a filter originally, however, when I put in the values, it filtered it in all pages, including the overall summary page, and we want to keep those values in the overall summary sheet, and then just exclude them from being split out into their own tab.

Re: How do I remove specific tabs in excel report

devarasu07 — Wed, 23 Aug 2017 17:59:12 GMT

Hi,

If it's fixed those values, try to filter at qlikview side using set analysis. duplicate sheets object for each business unit and overall tab in qlikview then u can call each chart object into qlikview nrpinting excel report.

thanks

Re: How do I remove specific tabs in excel report

devarasu07 — Wed, 23 Aug 2017 18:00:07 GMT

Hi,

can you share your mock data and working file. will check and help you accordingly. tks

Re: How do I remove specific tabs in excel report

Wed, 23 Aug 2017 18:14:00 GMT

I appreciate it, however the data I have is live, so I cannot post it, I will just keep looking at it and see if I can come up with something

Re: How do I remove specific tabs in excel report

Wed, 23 Aug 2017 19:28:18 GMT

Would a macro be able to do it, or is there another feature of NPrinting that might do it?

Re: How do I remove specific tabs in excel report

Thu, 24 Aug 2017 08:34:19 GMT

If no filters need to be applied for the business unit field to the first sheet for ANY recipient, then the solution is to apply chart specific filters which will "override selections" to all of the charts on the first sheet.

Steps:

Build filter which includes all the business units and select "clear selections" if it's NPrinting 16.x and "override values" if it's NPrinting 17.x
How to Apply a Specific Filter to Tables or Images
Open the template and apply the "all business units" filter to all objects on the first sheet
Apply the Page feature to the second sheet using the business unit field
Create a filter which filters out the business units for which you don't want worksheets to be generated and apply it to the report.

When you run the report, the business units filter should be applied to sheets 2 - N and therefore suppress the business units you don't want to see.

That filter won't be applied to the objects on the first sheet as they have the "all business units" filter applied.

HTH

Aran