Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Number Format as text

Hello,


I come to you, because I have a problem with a Number Format. when i export my spreadsheet on Excel,


I have formatted my Number with the function Num. '#,###.00%'.


But when send to excel the report, there are some errors about the formatting of the Number. i have to convert my text to Number...

How to solve my problem?

Thanks



1 Solution

Accepted Solutions
MVP
MVP

Re: Number Format as text

Hope to understand your question:

it seems if you export to excel a column with the same number format in all the values of that column, in excel you get a number (top 2 examples in image).

If you send to excel a column (red rectangle in image) with mixed format, in excel you get a text

1.png

7 Replies
MVP
MVP

Re: Number Format as text

Hope to understand your question:

it seems if you export to excel a column with the same number format in all the values of that column, in excel you get a number (top 2 examples in image).

If you send to excel a column (red rectangle in image) with mixed format, in excel you get a text

1.png

Not applicable

Re: Number Format as text

Thank you for the answer

Yes I import excel on a column with different formats.

But I do need that the result is excel surt the form of number, not in text.

vipin_mishra479
Contributor II

Re: Number Format as text

Wright your exp like

num(sum(Amount),0.00)

punitpopli
Contributor III

Re: Number Format as text

Hi CombealCIC‌,

Try with Num(#,##0.00%)

Thanks,

Punit

Re: Number Format as text

Please post the sample application

Not applicable

Re: Number Format as text

Thanks you, for the answer.

Sorry, I export my QlikView Spreadsheet to excel.

And I used Num(#,##0.00%) for the row with the %.

And Num(#,###.00' ) for the other row.

But I need to use two numbers formats different, cause I want to see in the same column number and pourcentage.

MVP
MVP

Re: Number Format as text

hope to be wrong but if you use 2 diffferent format in Qlik in the same column, when you send to excel you get a text (in excel)

Community Browser