Filter out Excel tab with paging when zero rows

[Lauri]

I have an Excel template with two tabs, and each tab uses paging on field "PCLoc". Each tab displays some text and data from one straight table in QS. Is it possible to tell NPRinting to NOT generate a tab for a value of PCLoc when it has zero rows in the table? 

The template looks like this:

[Lech_Miszkiewicz · Accepted solution]

The easiest approach is to use "Advanced Search" filter on the [PCLoc] field. You can create filters which will check if there are existing records like:

• Count(Distinct [Acct#]) >0 

Or if there is a measure use measure to filter only existing values. 

More about advanced search filters here:

• https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/
• https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/ReportsDevelopment/Static-dynamic-fi...

cheers

Lech