topic Re: 0 values are suppressed on Excel export in QlikView

0 values are suppressed on Excel export

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello. I'm having an issue with exporting some QlikView tables via a macro.
There are two rows that have missing values in Excel but have 0 values in QlikView. I've unchecked the "suppress missing" and "suppress zero values" but it still hasn't changed anything.
Any ideas?
Pictures for references

Re: 0 values are suppressed on Excel export

ychaitanya — Wed, 21 Mar 2018 13:43:38 GMT

could see same 8 rows in both the images. Can you highlight the missing rows ?

Re: 0 values are suppressed on Excel export

Anonymous — Wed, 21 Mar 2018 14:08:44 GMT

Here you go. The values are simply left blank in Excel but they have values in QlikView

Re: 0 values are suppressed on Excel export

ychaitanya — Wed, 21 Mar 2018 14:17:38 GMT

Hope you're trying a micro, can you try using the standard functionality of Qlik Send to Excel and see if the problem exists ?

then you could tune up macro if in-case it's coming properly in standard qlik functionality

Re: 0 values are suppressed on Excel export

Anonymous — Wed, 21 Mar 2018 14:27:02 GMT

I've tried using the built-in function of exporting to Excel from QlikView. The results are pretty odd.If I use the built-in function, it suppresses the zeros, but in the case of the two rows it actually places them as text. See the image below:

Re: 0 values are suppressed on Excel export

ychaitanya — Wed, 21 Mar 2018 14:43:53 GMT

i feel there are data type conversion issues around here.. try pasting as special in the macro code (or) before pasting the cells change the input type to Number in Macro code.

else we can also try using the Num(Expr, '#,##0.00') conversions in qlik expressions and setting the Expression Default in Number Tab

Re: 0 values are suppressed on Excel export

Anonymous — Wed, 21 Mar 2018 15:12:35 GMT

Paste special didn't worked and neither changing the format