Copying and Pasting From Qlikview

[braham]

I hope somebody on this forum can assist with a problem I am having. I need to copy a table from a Qlikview document and paste it into a Word document. The issue I am having is that when I paste the document it drops the thousands separator. In Qlikview my number is formatted to read 123,456.78. After pasting the decimal point is still there, but the ',' separator is missing and the figure looks like 123456.78.

I have tried configuring the copy and past options under the advanced setting of Word without success.

I am using Qlikview 12, Windows 7 on the desktop and Office 2016.

Thanks

Braham Edwards

[Anil_Babu_Samineni]

Have you used Num function in Qlikview to get same value? Can you show your expression to get the same

[sdmech81]

HI,

May be u can check for nymber formatting in World doc bcs in qlik it as desired..

Sachin

[braham]

Hi Anil

Thanks for the quick response. The num functions results in the same field format, and exports with the same issue.

[braham]

Hi Sachin

Sorry not following your reply. Can you expand it a bit more.

Braham

[sdmech81]

I mean any docsetting available to format in word doc itself..

[#7]

I get the same result, it seems Qlikview copies no thousand separator.

A workaround can be to first send the table to Excel, then copy the Excel table into Word, that works in my test.

[braham]

Hi Sven

Thanks for the reply. I have also achieved the desired outcome by pasting to Excel, but this doubles the work and time required to do this job. I am trying to save time.