topic Re: Losing format when export to excel in QlikView

Losing format when export to excel

alec1982 — Fri, 20 Jun 2014 13:49:20 GMT

Hi,

Is there anyway to keep the format of a straight table when exporting to excel?

Thxs,

Clever_Anjos — Fri, 20 Jun 2014 14:18:08 GMT

Formating every column using NUM() will help

alexandros17 — Fri, 20 Jun 2014 14:22:51 GMT

If your environmental variables (the ones you find in main script) are equal to those of your excel installation then export data will work exactly

its_anandrjs — Fri, 20 Jun 2014 14:24:40 GMT

If columns are Text then use Text(FieldName) or if it is Number Then Num(FieldName).

PrashantSangle — Sat, 21 Jun 2014 07:53:37 GMT

Hi,

For which field you are getting issue?

Kindly share screenshot or sample excel file where Format is changing.

Regards,