Skip to main content

Qlik NPrinting

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
LaureDenivelle
Partner - Contributor II
Partner - Contributor II

NPrinting Excel 2 tables side by side delete empty rows

Hi

Is it possible in Excel NPrinting report to have 2 table side by side and not creating empty lines like this : 

LaureDenivelle_2-1634051937995.png

NPrinting code : 

LaureDenivelle_1-1634051838197.png

I use Tables from QlikSense and not Levels.

The problem is the "total" line in fact that multiply all the lines... 

LaureDenivelle_0-1634052218683.png

 

regards

Laure

 

Labels (2)
1 Reply
Lech_Miszkiewicz

In short: This is working as expected. That is normal NPrinting behvaiour.

So It is not be possible using the approach you are taking. This is because you cannot add row in excel only for columns A:D (which is eaxactly what NPrinting does when populating data). Excel adds rows for all columns which is exactly what we see when we look at your results.

Workarounds:

thats it.

cheers

L

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.