Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
braham
Creator
Creator

Copying and Pasting From Qlikview

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

7 Replies
Anil_Babu_Samineni

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sdmech81
Specialist
Specialist

HI,

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

Sachin

braham
Creator
Creator
Author

Hi Anil

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

braham
Creator
Creator
Author

Hi Sachin

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

Braham

sdmech81
Specialist
Specialist

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

Not applicable

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
Creator
Creator
Author

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.