Discussion Board for collaboration on Qlik NPrinting.
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?
Qlik 11.2 SR12
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.
View solution in original post
Thanks Matus, Perfect!