Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.
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
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 !!
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.
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....