If it is small table like a summary, you can just use the Copy to Clipboard -> Full Table Option and you can paste it in your excel.(you will get exact qv format). Otherwise You need to check with Macro
I don't believe that this behaviour could be (easily) adjusted. While exporting or copying to excel some kind of TRIM will be applied and removed these chars. I think the reason is a meta-data error/incompatibility between QlikView and Excel then if I copy (as whole table into the switchboard) such table-chart into Notepad++ and copy it there again and paste it into Excel those control-chars remain.
Further worked it by exporting not to Excel else into a textfile like a *.qvo but I'm not sure if this resulting format is what you want. Then remained the possibility to work afterwards with some macros or to make the whole export + adjustment within vbs - attached is an recent post to fill missing dimension-values after copying the object and which could serve as starting-point if such a solution will be preferred.
Of course the easiest way is to avoid such linebreaks maybe with another specialized chart-object which only purpose is to export and which won't used from your users.
Thanks for this. This works for me when in Qlikview but the front end users dont have this option in the browser. I may have to use this as a workaround for the time being
