Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

wonkymeister
Contributor

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

Tags (1)
1 Solution

Accepted Solutions
mkelemen
Contributor III

Re: NPrint - Excel - Hide Trailing Empty Rows

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

2 Replies
mkelemen
Contributor III

Re: NPrint - Excel - Hide Trailing Empty Rows

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

wonkymeister
Contributor

Re: NPrint - Excel - Hide Trailing Empty Rows

Thanks Matus, Perfect!

Community Browser