topic Re: Extra spaces when exporting to Excel in QlikView

Extra spaces when exporting to Excel

Thu, 17 Nov 2016 13:28:38 GMT

Hello,

Sometimes I have to create huge tables in QV and export them to excel.

I've noticed that when I export tables from QV to Excel the empty cells are not "" but " ".

Removing the empty spaces in excel shrinks the files from 15 MB to 5 MB (500 000+ spaces are being removed).

I was therefore thinking if these spaces are also stored in QV causing the qvw files to work slower. Is there an easy way to check this?

Re: Extra spaces when exporting to Excel

stabben23 — Thu, 17 Nov 2016 14:03:40 GMT

Hi,

you can add =len(YourFileld) inside a textbox and se no of Spaces.

Re: Extra spaces when exporting to Excel

el_aprendiz111 — Thu, 17 Nov 2016 20:41:47 GMT

Hi Carl

examples that will help you in the script to load data

TABLE:
LOAD
TRIM(COUNTRY)   AS COUNTRY,
NUM(VALUE)      AS VALUE,
NUM(VALUE_1)    AS VALUE_1,
NUM(VALUE_2)    AS VALUE_2,
NUM(VALUE_3)    AS VALUE_3;

Re: Extra spaces when exporting to Excel

Clever_Anjos — Thu, 17 Nov 2016 21:01:18 GMT

"I export tables from QV to"

How do you export your files?