https://community.qlik.com/t5/Qlik-NPrinting/Filter-out-Excel-tab-with-paging-when-zero-rows/m-p/1919456#M35756 <P>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?&nbsp;</P> <P>The template looks like this:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Lauri_0-1650298724097.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/77309iCFC71BC1AB2DC157/image-size/medium?v=v2&amp;px=400" role="button" title="Lauri_0-1650298724097.png" alt="Lauri_0-1650298724097.png" /></span></P> <P>&nbsp;</P> Mon, 18 Apr 2022 16:20:26 GMT Lauri 2022-04-18T16:20:26Z https://community.qlik.com/t5/Qlik-NPrinting/Filter-out-Excel-tab-with-paging-when-zero-rows/m-p/1919456#M35756 <P>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?&nbsp;</P> <P>The template looks like this:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Lauri_0-1650298724097.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/77309iCFC71BC1AB2DC157/image-size/medium?v=v2&amp;px=400" role="button" title="Lauri_0-1650298724097.png" alt="Lauri_0-1650298724097.png" /></span></P> <P>&nbsp;</P> Mon, 18 Apr 2022 16:20:26 GMT https://community.qlik.com/t5/Qlik-NPrinting/Filter-out-Excel-tab-with-paging-when-zero-rows/m-p/1919456#M35756 Lauri 2022-04-18T16:20:26Z https://community.qlik.com/t5/Qlik-NPrinting/Filter-out-Excel-tab-with-paging-when-zero-rows/m-p/1919555#M35757 <P>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:</P> <UL> <LI>Count(Distinct [Acct#]) &gt;0&nbsp;</LI> </UL> <P>Or if there is a measure use measure to filter only existing values.&nbsp;</P> <P>More about advanced search filters here:</P> <UL> <LI><A href="https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/" target="_blank">https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/</A></LI> <LI><A href="https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/ReportsDevelopment/Static-dynamic-filters.htm#anchor-9" target="_blank">https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/ReportsDevelopment/Static-dynamic-filters.htm#anchor-9</A></LI> </UL> <P>cheers</P> <P>Lech</P> Mon, 18 Apr 2022 22:15:50 GMT https://community.qlik.com/t5/Qlik-NPrinting/Filter-out-Excel-tab-with-paging-when-zero-rows/m-p/1919555#M35757 Lech_Miszkiewicz 2022-04-18T22:15:50Z