Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Re: Problem export excel number format num(..)

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

joaquinlr
Valued Contributor II

Re: Problem export excel number format num(..)

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.

Not applicable

Re: Problem export excel number format num(..)

thanks a lot

did you reopen the case with the QlikTech Support ?

joaquinlr
Valued Contributor II

Re: Problem export excel number format num(..)

HI

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

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

Highlighted
joaquinlr
Valued Contributor II

Re: Problem export excel number format num(..)

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

Re: Problem export excel number format num(..)

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
Contributor

Re: Problem export excel number format num(..)

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.

Not applicable

Re: Problem export excel number format num(..)

Hello

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

Did someone found a workaround ?

Thanks

joaquinlr
Valued Contributor II

Re: Problem export excel number format num(..)

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
Contributor

Re: Problem export excel number format num(..)

Thanks very much. That option works OK.

Community Browser