Problem export excel number format num(..)

[jonathan_dau]

Hi everyone,

I'm sorry if my issue was already solved in another post but I couldn't find the answer to my problem.

Actually here it is:

I have a table where I'm calculating different stuff as Margins, Volumes of sales and so on.

For one of the indicator I'm calculating volumes for diffents things (volume in terms of turnover or volume in term of number of sales for instance).

As I cannot use one single format for the numbers I use the

- NUM(expression, format-code ('# ##0')) for numerical

- NUM(expression, format-code ('# ##0 €')) for monetary units

Everything's fine so far but the problem is when I export the table on Excel.

Excel doesn't recognize the format I've defined and display the values as Text which is bad when we want to use the Excel file for other calculation.

Do you have any idea of how I can deal with that.

Thanks in advance

[#2]

Hi,

I have the same issue even with v11 SR2 (calculated dimension formatted with num())

did you finally upgrade to SR2 and did it solve your problem ?

Thanks

[JoaquinLazaro]

Hi richardhooft:

I installed QV 11 SR2 but the bug remains as in SR1.

Look at this message http://community.qlik.com/message/269503#269503 ... I wrote all the test I've been done to check if it was corrected.

[#4]

thanks a lot

did you reopen the case with the QlikTech Support ?

[JoaquinLazaro]

HI

No, I don't know how to do it.

Please, if you do send me the link to have a look.

[JoaquinLazaro]

Hi:

Following the instructions on this article https://eu1.salesforce.com/articles/Basic/How-to-export-data-to-excel-as-number-in-version-11?popup=... at the customer portal I've found the way to export numeric fields as numeric cells ... but unformatted.

[amien]

anyone still got the document mentioned above from salesforce? link is not working.

TEXT is working, but i really want to have a NUM() to excel.

[sangland2]

Hi, I have 11.2 SR4 and this is still a problem. If a number is formatted as Money on the Number tab then this exports OK. If the expression uses Money and '$#,##0.00;-$#,##0.00' and expression default is used in the number tab, then the QV displayed value is correct, but the value exports to Excel as text. I need conditional formatting of columns and this is done in the expression.

[#9]

Hello

I have the same issue in QV 11 SR10 with Num() and export to excel...

Did someone found a workaround ?

Thanks

[JoaquinLazaro]

Hi claudiasoares

There are two possibilities send numbers formatted as text (with dots and periods) but not excel numbers or send real numbers in excel but without numeric format.

Follow this instructions and chose which one you like it.

Hope I helped you

Joaquín

[sangland2]

Thanks very much. That option works OK.