topic Re: Text in a table truncated when sent to Excel in QlikView

Text in a table truncated when sent to Excel

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am loading some data from several Excel file using a script in QV.

Some the fields are text values (comments), others are numbers.

When I try to display the text fields in QV, it looks like the text values are truncated to 252 characters when I send data to Excel table.

I am using set analysis as follows :

MaxString({<Indicator_ID = {'LEAD_Highlights'}>}Data)

where LEAD_Highlights is the name of the field I wold like to display

The text is properly displayed as a yellow pop-up window when I point my mouse over the table, but when sending to Excel it is truncated to 252 characters.

Thanks a lot for your help.

Nicolas

Re: Text in a table truncated when sent to Excel

tomasz_tru — Tue, 20 Feb 2018 17:42:56 GMT

is it *.xls or *.xlsx?

Re: Text in a table truncated when sent to Excel

isingh30 — Tue, 20 Feb 2018 18:56:08 GMT

Please check the filetype of the excel sheet. It should be .xlsx.

Thanks.

Re: Text in a table truncated when sent to Excel

Anonymous — Wed, 21 Feb 2018 13:01:11 GMT

I am using the XL button and it seems that by default QV is generating a xls file not xlsx. I have browse the knowledge base, tried to write a macro to generate an xlsx file but this does not work so far. I would be interested if there is a native feature in QV to generate xlsx and avoid using macros.

Re: Text in a table truncated when sent to Excel

isingh30 — Wed, 21 Feb 2018 14:50:22 GMT

Can you share your file? Let me know.

Thanks.