Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Copy to clipboard number format

Hi expert

I have a table when i try to copy to clipboard and paste it into excel, all the number format gone

What i got:

2.PNG.png

Desired output:

Capture.PNG.png

1. comma (,) as thousand separator

2. negative value should be in bracket()

3. Variance in one decimal place

Any one got idea how this could happen and how to solve it?

6 Replies
Anonymous
Not applicable
Author

anyone know how to solve this?

qlikpahadi07
Specialist
Specialist

Hi Surynn,

Sorry to reply PFA

Instead in Expression you can Format in "Number" Tab which will solve the issue in Export.

Hope this help Cheers !!!

Anonymous
Not applicable
Author

I can't set the format in the "Number" tab because my actual table contains a mixed format of data, under the same column may contain numeric value and percentage although my attached didn't simulate that.

PrashantSangle

Hi,

Hi,

Please find attached file.

Regards,

PS

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
qlikpahadi07
Specialist
Specialist

if your same column contains mix format than its tough to apply.

You should attach your sample in that format with proper Query it was solution to the query which you attached and highlighted .

qlikpahadi07
Specialist
Specialist

adding to previous I suggest you must edit your Query to avoid confusion or close/delete this thread and create a new one.