Solved: Re: NPrinting Excel populate blanks - Qlik Community

david_pearson · ‎2021-03-09

Hi all

i'm creating an Excel document in Nprinitng. When the report is created I have some blank cells in the data which is correct however they are automatically populated with a "-" symbol. Is it possible to create the report so that it leaves blank cells blank? Or at the very least change it to something else? I would normally just manage it with a find and replace but there are "-" symbols used in other cell values which would be affected if i did this.

thanks

Ruggero_Piccoli · ‎2021-03-09

Hi,

When you open a new conversation, please remember to add the label with the correct version of Qlik NPrinting and specify what type of template you are developing, if you are connecting to QlikView or Qlik Sense etc. Thanks

In your case I suppose you are exporting a table from QlikView or Qlik Sense. In that case you could set the null value symbol in the source document:

Best Regards,

Ruggero

Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

View solution in original post

Ruggero_Piccoli · ‎2021-03-09

Hi,

When you open a new conversation, please remember to add the label with the correct version of Qlik NPrinting and specify what type of template you are developing, if you are connecting to QlikView or Qlik Sense etc. Thanks

In your case I suppose you are exporting a table from QlikView or Qlik Sense. In that case you could set the null value symbol in the source document:

Best Regards,

Ruggero

Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

david_pearson · ‎2021-03-09

thank you. noted for future. i have checked and it's the source data table. the nulls are represented as "-" which carries through as a value. i will code around this. thanks