Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Nprinting: using deleterow function

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Joseph_Musekura
Support
Support

Nprinting: using deleterow function

Last Update:

Sep 14, 2020 8:55:32 AM

Updated By:

Sonja_Bauernfeind

Created date:

Oct 20, 2017 2:08:39 AM

In Nprinting, deleterow function is used to remove a blank row between data you pull in from a qlik application. It can typically be used to remove blank spaces between data and totals.

User-added image

 

Resolution:


From below settings, the result shows 3 empty rows on the top of the straight table and 2 empty rows between the last line of data and a total sum.
 

User-added image


Result of above settings: 3 blank lines on top of the table and 2 blank before the total


User-added image and  User-added image


Adding "deleterow" in the column A (as shown below), removes some empty rows on the top of the straight table and between the last line of data and a total sum.

 

User-added image
 


As result, only one empty line is displayed.
 

User-added image and User-added image
Labels (1)
Comments
mjht
Creator
Creator

why wouldn't you just bring out Product Name to cell C2 instead of C4 if you only wanted 1 blank line?

I don't really understand why deleterow would be needed

Contributors
Version history
Last update:
‎2020-09-14 08:55 AM
Updated by: