topic Re: I am having a problem exporting data to excel. in QlikView

I am having a problem exporting data to excel.

Wed, 12 Mar 2014 20:48:42 GMT

I have a column called CNAE has the following format 0000-0/00 in Qlikview it remains intact but when I export pro excel, some of them are in date formatting.

I've tried formatting the excel for number / general but the numbers are backwards.

Re: I am having a problem exporting data to excel.

stevedark — Wed, 12 Mar 2014 20:52:41 GMT

This will be an Excel issue, where it is messing up the data once it has received it. If you change the format on the column to Text does it resolve the issue?

Sometimes these things are not simple to resolve properly, you could append a prefix on the field, eg CN:0000-0/00 to avoid Excel messing it up.

- Steve

Re: I am having a problem exporting data to excel.

Wed, 12 Mar 2014 20:57:05 GMT

How do I do that for all data in that column?

Re: I am having a problem exporting data to excel.

stevedark — Wed, 12 Mar 2014 21:04:58 GMT

Your best bet is to do it at load time, replace the line where CNAE is loaded with,

'CN:' & CNAE as CNAE,

Or if you want to have both prefixed and un-prefixed versions you could do:

CNAE,

'CN:' & CNAE as CNAEPrefixed,

It is possible to add the prefix on just for a single chart, by clicking the Calculated Dimension button where you have CNAE as a dimension - but this is much less performant than doing it in the load script.

- Steve

Re: I am having a problem exporting data to excel.

Clever_Anjos — Wed, 12 Mar 2014 21:57:16 GMT

One trick that can help you

add an empty space before the CNAE

add CHR(39) before the CNAE