One of the column is blank on downloading the report from QS

[AST_42]

i have a requirement to replace the 0s in column ID with 'NA**' so i changed field expression to

=If(ID= 0,'NA**', ID)

After changing this the changes looks good in QLIK, as shown below:

But when i download this report using a button in QS, ID column has no data in Excel as shown:

Can anyone suggest why is this happening?

Thanks in Advance.

[Sweta_Sharma]

Hi AST_42,

I've tested the same at my end and it's exporting correctly in excel/pdf/image. Which option you've chosen to export the report (excel/image/pdf)?
What's the version of Qlik Sense used? If possible could you please share the app copy?

Cheers!