Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

ronaldwang
Contributor

Nprinting excel report null value

when exporting in cell or column format (de-selecting source format). if the cell value is null. the source format will still be kept. anyone know how to solve the issue? (apart from changing the expression to convert null to zero) thanks

2 Replies
Lech_Miszkiewicz
Honored Contributor III

Re: Nprinting excel report null value

from QlikView or QlikSense?

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
ronaldwang
Contributor

Re: Nprinting excel report null value

Hi Lech,

It is from QlikView. that is when the cell value is null, the border of the cell will disappear. as long as the cell value is not null, it is all good.

Community Browser