topic Re: Send to excel: numbers appear as text in QlikView

Send to excel: numbers appear as text

paul_ripley — Thu, 14 Jul 2016 15:19:07 GMT

Hello

When I send to excel on the server then the numbers are exported in General format

When I send to excel from the Access Point then the numbers look ok at first, although they are showing in 'Protected View' . As soon as I click 'Enable editing' then the numbers appear as text format.

Do you know if there is a way to have the numbers from the Access Point appear as numbers rather than text (is it the protected view that is the issue?)

Thanks

Paul

Re: Send to excel: numbers appear as text

squeakie_pig — Thu, 14 Jul 2016 15:49:56 GMT

Set the number format in the Numbers tab instead of using Expression Default

Re: Send to excel: numbers appear as text

paul_ripley — Thu, 14 Jul 2016 15:53:33 GMT

It is already set as 'Number' in the document settings. Is there somewhere else this need to be set?

Re: Send to excel: numbers appear as text

squeakie_pig — Thu, 14 Jul 2016 16:29:15 GMT

The Number tab in the Chart Properties.

Re: Send to excel: numbers appear as text

paul_ripley — Fri, 15 Jul 2016 10:36:24 GMT

This field is a dimension, not an expression. When I change the Numbers tab, it just affects the Expression numbers not the format of the dimension

Re: Send to excel: numbers appear as text

squeakie_pig — Fri, 15 Jul 2016 13:22:49 GMT

You could force it by making it a calculated dimension

num#(fieldname,'#,##0') or if that doesn't work, force it in the script, num(EVALUATE(fieldname),'#0')