Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

NPrint - Excel - Hide Trailing Empty Rows

Morning

does anyone know if its possible to automatically hide the empty rows in excel when a report is produced by NPrint?

I.e. NPrint may produce a report with 50 rows of data - i'd like to hide all of the remaining rows as they're blank.

is this possible?

cheers,

Phil.

NPrint 16.5

Qlik 11.2 SR12

1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

Hi Phil,

it is possible.

In the template select all rows under your table tag (ctrl+shift+down arrow) and hide them.

Make sure you have the Expand range checkbox set on your table.

Btw. you can hide the columns the same but there is no expanding of columns so you need to leave as many columns visible as you will get.

BR,

  Matus

View solution in original post

2 Replies
Highlighted
Creator III
Creator III

Hi Phil,

it is possible.

In the template select all rows under your table tag (ctrl+shift+down arrow) and hide them.

Make sure you have the Expand range checkbox set on your table.

Btw. you can hide the columns the same but there is no expanding of columns so you need to leave as many columns visible as you will get.

BR,

  Matus

View solution in original post

Highlighted
Creator
Creator

Thanks Matus, Perfect!