topic Re: How to amend 'Send to Excel' format in QlikView

How to amend 'Send to Excel' format

paul_ripley — Mon, 07 Sep 2015 15:15:18 GMT

Hello

Is it possible to 'send to excel' a table but the numbers be in number format rather than as text?

Thanks

Paul

Re: How to amend 'Send to Excel' format

simondachstr — Mon, 07 Sep 2015 15:40:57 GMT

They should be exported as number format automatically unless you have at least one row which contains a string. If you still struggle I recommend explicitly formatting your expressions using num() or by setting the formatting in the chart properties.

Re: How to amend 'Send to Excel' format

paul_ripley — Tue, 08 Sep 2015 08:16:45 GMT

Thanks Martin, there is one row that is a string. I cant see in the chart properties though how I can force it to be treated as a number. The column is a dimension rather than an expression.

Re: How to amend 'Send to Excel' format

jonathandienst — Tue, 08 Sep 2015 08:24:34 GMT

You could try Document Properties | Number and set a numeric format for the dimension field. I am not sure whether that will override QV's data type logic in the the export, but its what I would try.

Re: How to amend 'Send to Excel' format

simondachstr — Tue, 08 Sep 2015 08:52:45 GMT

This will be tricky then - try loading your dimension as a dual field. Maybe that could help (didn't try it!).

Re: How to amend 'Send to Excel' format

Anonymous — Tue, 08 Sep 2015 09:01:17 GMT

Hi Paul, I've been down this road a few times, this will work if have your number format in your QlikView table exactly the same as in excel. This is usually set in your regional settings on your windows control panel. If they are identical excel will recognize them as numbers. It's usually the digit grouping that causes a mismatch.

Re: How to amend 'Send to Excel' format

paul_ripley — Tue, 08 Sep 2015 09:14:25 GMT

Thanks Jonathan, this worked for me.

Thanks everyone for your advice.

Paul