Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
ronaldwang
Creator III
Creator III

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
Partner Ambassador/MVP
Partner Ambassador/MVP

from QlikView or QlikSense?

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
ronaldwang
Creator III
Creator III
Author

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.