Number formats in excel export with many zeros

[AntonioLopez]

Hello,

Lately, we are having some problems with the exports from qlikview and qliksense to Excel.  The exports were working fine before, but now,  the number format is changed from "20,00" to "20,000000000000" for all numeric values.  The problems happens:

- Exporting data from qliksense table to excel.

- In Nprinting reports.

We have qliksense june 2020 , Nprinting february 2019, Qlikview November 2018 SR3, Microsoft Excel for Microsoft 365 MSO (16.0.13001.20254) 64 bits.

We have tried to put the expresion: 

        num(Round(x,0.01),'#.##0,00')  as x

in the script, but doesn't fix the problem 

Many thanks,

Antonio

[klas_lavenius]

Hi .

We have the same problem . And it started with Qliksense June 2020.  

It seems it only shows when You have numeric datagroups displayed as dimensions, and also it only shows on "some" Numerical dimensions. 

The problem appears even when You download from an app, that has not been updated with new data after the release upgrade , so it must have somthing to do with the way Qlik "feeds" excel . 

It is most irritating , and we're having a number of unhappy endusers. 

One way to live through the summer is to MANUALLY format the columns in Excel after each export.

That is NOT a good solution, so we are really waiting for Qlik to fix this !!

Rgds

Klas

[kobidaniel112]

Hi,

I have qlik sense june 2020 and experiencing the same issue.

I've managed to solve it by using Num() function on the numerical dimension

Example : use Num(NumDim) instead of just NumDim.

Of course it's not the optimal solution and i hope qlik will patch this issue, but it a workaround that sets the enduser free of this issue.   

[AntonioLopez]

Many thanks for your answer, in our case we can't do that for all the reports because we have a lot.... I hope that qlik will develop that patch soon....

[klas_lavenius]

Hi there .  I have another , maybe easier , solution , 

In the script Use 

round(NumDim) as NumDim,

Then its done once and for all (in that app ) 

Rgds

Klas

[kobidaniel112]

Thank! 

Works for me as well

[Udo]

Hi, does anyone know, if that's an official bug or if that's already solved in a later version?

[klas_lavenius]

Hi . I just checked my Case at support , and , according to the status, it is a "Pending  Bug,  Approved " , waiting to be solved.

Merry christmas , Maybe 😊

rgds

Klas

[MarioR]

Hi! I'm having the same issue. Is this still unsolved? Or is it just my Qlik Version?

[klas_lavenius]

Hi there .

as far as I know the issue is solved , Dont remember the exact veriosn , but some of the latter last year (2020) I think .

Rgds

Klas