Qlik Community

Ask a Question

Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
AntonioLopez
Contributor
Contributor

Number formats in excel export with many zeros

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

 

 

 

 

Labels (4)
7 Replies
klas_lavenius
Partner
Partner

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
Partner
Partner

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
Contributor
Contributor
Author

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
Partner
Partner

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
Partner
Partner

Thank! 

Works for me as well

Udo
Contributor II
Contributor II

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

klas_lavenius
Partner
Partner

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