Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

surynnchin
New Contributor III

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
Highlighted
surynnchin
New Contributor III

Re: Copy to clipboard number format

anyone know how to solve this?

qlikpahadi07
Valued Contributor

Re: Re: Copy to clipboard number format

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 !!!

surynnchin
New Contributor III

Re: Copy to clipboard number format

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.

Re: Re: Copy to clipboard number format

Hi,

Hi,

Please find attached file.

Regards,

PS

qlikpahadi07
Valued Contributor

Re: Copy to clipboard number format

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
Valued Contributor

Re: Copy to clipboard number format

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