topic Re: Wrap text issue when exported to Excel in QlikView

Wrap text issue when exported to Excel

Anonymous — Tue, 25 Sep 2018 05:06:32 GMT

Hi,

I am trying to figure out a way to retain the wrap text formatting that I have in one of my charts when I export to Excel. When I send to Excel the wrap text format is gone.

My expression in the chart is like:

Dim_1&chr(13)&Dim_2

Dim_1 and Dim_2 are two fields in the datamodel and I need to have them in separate lines. I am able to accomplish this in QlikView chart with the Expression and checking the Multiline option in the Presentation tab.

But when I export to Excel the wrap text format is gone.

Is Macro the only way. If yes, can anyone help me with the Macro.

Thanks,

Srikanth

Re: Wrap text issue when exported to Excel

Miguel_Angel_Baeyens — Tue, 25 Sep 2018 07:32:18 GMT

In the resulting Excel file, click on the row and then "Wrap text", unless wrapping is already enabled (if such thing is even possible I don't know).

Use Chr(10) & Chr(13) if the chart is used in both web view and ready to export.

Re: Wrap text issue when exported to Excel

uacg0009 — Tue, 25 Sep 2018 07:38:13 GMT

Hi Srikanth,

I found a way, but you need to click a button in excel after you export...I don't know whether there is a better way...

Firstly you need to use chr(10) not chr(13)

And then after you export to excel, you need to choose the corresponding column, and click below button in red circle in excel:

Sorry it's Chinese system, the button means Auto Wrap.

You can have a try.

Thanks.

Aiolos

Re: Wrap text issue when exported to Excel

Anonymous — Tue, 25 Sep 2018 14:33:10 GMT

Thank you it worked!!

Re: Wrap text issue when exported to Excel

Anonymous — Tue, 25 Sep 2018 14:35:26 GMT

Thank you Miguel!!

So should my expression be like

Dim_1&chr(10)&chr(13)&Dim_2

Thanks,

Srikanth

Re: Wrap text issue when exported to Excel

Miguel_Angel_Baeyens — Tue, 25 Sep 2018 15:45:02 GMT

Yes, exactly. Still, you need to enable the wrap text on Excel.