Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Join us for live office hours! Q&A with Qlik on Dec 14 at 10am EST: Refining Reports and Visualizations
Showing results for 
Search instead for 
Did you mean: 

Nprinting suppress Zeros

Hi -

Current setup: I've got a Qlik dash with one table. The table has suppress zeros on the table (table > data handling > include zero values is unticked) - this works perfect and is exactly what i need.

The problem: In Nprinting i'm using individual fields to create a table, mainly because the formatting of the excel file is quite unique. Its setup however in the same table/rows format.  The problem is it includes all the zero lines, i.e. the rows that include either 0 or -.  

I've read if you insert a 'table' in nprinting it will work as per the qlik dash, however as mentioned i can't, im currently using fields. Does anyone know a solution for this at all?


Labels (2)
1 Reply

Hi, the bit i dont understand is why cant you put your Qlik Sense table into a level? This is exactly what everyone will suggest to you as a solution.

Whatever you do with individual fields in NPrinting can still be done. 

I am assuming you missunderstood what you have read: I've read if you insert a 'table' in nprinting it will work as per the qlik dash... This means that you can put your table in NPrinting level to prevent it from looping through dimension values where all measures in the table return 0 (which is exactly what you want) and you can still use individual fields in your template same as you are doing it now! Just try and and instead of using field level, add your table as a level.

hope it makes sense.. 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.