Skip Sheet If No Data Found

[MHarrell]

Hi All,

I've got a report that Cycles through entities and produces eight output files.  Each of those files will have data on as many as fifteen sheets, however some entities will not have data on every sheet.  Is there a way I can tell NPrinting to skip the sheet and move to the next if no data is found instead of it producing the template with no data?  Any help would be greatly appreciated!  

[Ruggero_Piccoli]

Hi,

A field can be added to the Pages node as documented in http://help.qlik.com/en-US/nprinting/June2019/Content/NPrinting/ExcelReports/Create-Excel-Reports.ht... or in http://help.qlik.com/en-US/nprinting/June2019/Content/NPrinting/PowerPointReports/Page-Features.htm

In the Pages node you can also add Straight Tables. This will create a new Page for each single row of the table.

Then inside a page you can drag and drop all objects you want. 

Best Regards,

Ruggero

[michaeldburt]

Worked great, thanks.

Only thing that is not clearly defined is the method.  Qlik Sense and NPrinting don't allow for you to bring in straight "tables" with more than 1 column. 

So, I created the table with the 1 column i needed, and used report-level filters in NPrinting to recreate the Set Analysis modifiers used in the table I am building the report off of to limit the table/pages that are created.

[Ruggero_Piccoli]

Hi,

You can add a Qlik Sense straight table with multiple columns in the Levels node.

Maybe you tried to add a pivot table.

Best Regards,

Ruggero