topic Excel Template Page Feature - Exclude 0-value pages in Qlik NPrinting

Excel Template Page Feature - Exclude 0-value pages

Jan-Hendrik — Fri, 27 Mar 2020 14:13:30 GMT

I’m using the page feature in the nprinting Designer Excel template

It produces a page in the report for each [Main Product Group] value, for example

But when there is no value for a specific Main Product Group, it still produces a empty report

I know that you can use Conditions in nPrinting stop a Task or a specific report, but I can’t find anything that can be used to stop the empty pages being produced,

On the Qlik Sense object side, I did make sure that the Include Zero Values option is not selected

This is what shows in the Qlik Sense object when you filter on the value

So, the question is, is there a way to stop nprinting from showing the 0-value page when using the page feature in a excel template, but keep the pages where the dimension value has measure values

Re: Excel Template Page Feature - Exclude 0-value pages

Ruggero_Piccoli — Fri, 27 Mar 2020 16:20:06 GMT

Hi,

Adding the field [Main Product Group] in the Pages node will produce a worksheet for each distinct value of the field, also if there are no data.

Instead create a straight table in the source app. Insert the field [Main Product Group] ad dimension and, for example, the total sales, in order to have only rows with data. Refresh the connection cache, close and reopen the Designer and add that table in the Pages node. You will have a worksheet for each row, but you have only rows with data so this should solve.

Best Regards,

Ruggero

Re: Excel Template Page Feature - Exclude 0-value pages

Lech_Miszkiewicz — Sat, 28 Mar 2020 01:48:06 GMT

hi @Ruggero_Piccoli

are you sure - I tried it nd it did not work for Page tag when i tried using table. I think this is not 100% clear when we can use table as Page or Level. In PPT template Table as Page worked well, but in Excel does not as it needs to know which value needs to be put as label for sheers

Instead my approach is to use Advanced Search filter to only filter values with measure <> 0

https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/

Re: Excel Template Page Feature - Exclude 0-value pages

Jan-Hendrik — Sat, 28 Mar 2020 05:47:01 GMT

Thank you @Lech_Miszkiewicz

I followed your advise using Advance Search on a filter, the properties I used:

- Name: [Main Product Group] - the field used in the Page feature on the Excel template

- Advance Search - I copied the object's first measure expression and added a <>0

- I tested this and all pages except the those with no value showing

Thank you so much, stay safe!