topic Number formats in excel export with many zeros in Management & Governance

Number formats in excel export with many zeros

AntonioLopez — Sat, 16 Nov 2024 18:21:30 GMT

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

Re: Number formats in excel export with many zeros

klas_lavenius — Thu, 16 Jul 2020 08:13:06 GMT

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

Re: Number formats in excel export with many zeros

kobidaniel112 — Wed, 04 Nov 2020 08:52:18 GMT

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.

Re: Number formats in excel export with many zeros

AntonioLopez — Wed, 04 Nov 2020 09:38:39 GMT

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

Re: Number formats in excel export with many zeros

klas_lavenius — Wed, 04 Nov 2020 10:06:58 GMT

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

Re: Number formats in excel export with many zeros

kobidaniel112 — Wed, 04 Nov 2020 11:20:13 GMT

Thank!

Works for me as well

Re: Number formats in excel export with many zeros

Udo — Thu, 03 Dec 2020 12:37:00 GMT

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

Re: Number formats in excel export with many zeros

klas_lavenius — Fri, 04 Dec 2020 09:40:35 GMT

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

Re: Number formats in excel export with many zeros

MarioR — Mon, 18 Oct 2021 17:58:20 GMT

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

Re: Number formats in excel export with many zeros

klas_lavenius — Thu, 28 Oct 2021 08:02:46 GMT

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