topic Zero represented as blank in xls export (unwanted) in App Development

Zero represented as blank in xls export (unwanted)

giu_mancuso — Tue, 06 Aug 2019 07:47:06 GMT

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.

Re: Zero represented as blank in xls export (unwanted)

Aditya_Chitale — Fri, 03 Sep 2021 09:41:54 GMT

@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

Re: Zero represented as blank in xls export (unwanted)

Digvijay_Singh — Fri, 03 Sep 2021 13:21:57 GMT

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/1805749

Re: Zero represented as blank in xls export (unwanted)

shloime — Mon, 04 Oct 2021 16:53:04 GMT

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/

Re: Zero represented as blank in xls export (unwanted)

Frank_S — Mon, 27 Mar 2023 15:52:59 GMT

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-a00e9e476b03#ID0EBF=Newer_versions