Zero represented as blank in xls export (unwanted)

[giu_mancuso]

Hi,

QS is behaving strangely after the upgrade Feb2018 enterprise to Apr2019 enterprise (but also in my Feb2019 Desktop).

When exporting a table to excel, the cells which contain a zero are represented as blank. The value is present in the cell (you can see it when you click on it) but it happears as blank.

if you look at the format in xls you see the following:

This is the code I used to create a table containing numbers from 0 to 9:

load RowNo()-1 as riga
AutoGenerate 10;

It does not happen if I slitly change the code to:

load (RowNo()-1)/3 as riga
AutoGenerate 10;

In this case the format in excel is the generic one:

1) Has anyone experienced the  same issue?

2) Is there any way to fix it for the entire app? Maybe using some kind of variable similar to MoneyFormat. I have thousands of fields and it is unthinkable to change the format one by one.

Thank you for your support.

[Aditya_Chitale]

@giu_mancuso  Facing same issue. Did you find any solution ?

In my case, I am able to see values in Qlik Dashboard but when I export to excel, the cells show null value. And as mentioned by you when I click on the cell, it shows value as 0 on the value bar.

Qlik Screenshot:

Exported Excel Screenshot:

Regards,

Aditya

[Digvijay_Singh]

Looks like this behavior persists (haven't tested yet) when dimension is exported. For measure if number format is used, it exports properly, I just saw this post with similar issue - 

https://community.qlik.com/t5/New-to-Qlik-Sense/Zeroes-values-disappear-when-exporting-to-Excel/td-p...

[shloime]

With the LogiExport extension for QlikSense you can control the formatting of the exported file:

https://logiexport.logsys.co.il/documentation/

https://logiexport.logsys.co.il/articles/how-to-easily-control-the-values-formatting/

[Frank_S]

Hello team,

This is dependent on Microsoft Excel and can be managed therein with newer MS excel versions that support this output managment feature.

See https://support.microsoft.com/en-us/office/display-or-hide-zero-values-3ec7a433-46b8-4516-8085-a00e9...