Number format changed when sent to Excel - Qlik Community

manh_nguyen · ‎2017-12-11

Dear Qlik Community,

Since updating to QlikView 12 November from (QV 11.20) I have the problem that the number format completely changes when exporting to Excel.

Excel Export:

Does anybody have a solution for this problem?

Kind Regards,

Manh

Anil_Babu_Samineni · ‎2017-12-11

How you are exporting?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anonymous · ‎2017-12-12

Was this chart created in QV!1? if yes can you re-create the chart and check once

Or · ‎2017-12-12

In addition to re-creating the chart as suggested by Hari, you could try explicitly formatting the expression using Num(YourExpression,'#,##0.00') - set it back to expression default and see if that works correctly.

manh_nguyen · ‎2017-12-12

Hi, I'm exporting via the Excel Export Button.

manh_nguyen · ‎2017-12-12

No this was created in QV 12.20.

manh_nguyen · ‎2017-12-12

This is unfortunately not an option for my customer. This would lead to too many changes on their part. This was just a Demo Application from my side showing that QV 12.20 has issues with this even on the simplest level and with a native 12.20 Application.

Or · ‎2017-12-12

Ah, now the issue is clear. You listed it as being version 11.2, but you actually meant 12.2 - I read the number and not the text.

There's at least one formatting-export bug in 12.2, and this may be another one. I'd suggest you downgrade to 12.1 and see if that solves your problem.

manh_nguyen · ‎2017-12-12

Ok thank you that seems to be the only way.

nboccassini · ‎2020-07-24

I've solved with:

Num#(Num(field,'format'))