topic Re: Re: Copy to clipboard number format in QlikView

Copy to clipboard number format

Anonymous — Wed, 26 Mar 2014 14:17:33 GMT

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:

Desired output:

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?

Re: Copy to clipboard number format

Anonymous — Thu, 27 Mar 2014 01:46:36 GMT

anyone know how to solve this?

Re: Re: Copy to clipboard number format

qlikpahadi07 — Thu, 27 Mar 2014 07:54:46 GMT

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

Re: Copy to clipboard number format

Anonymous — Thu, 27 Mar 2014 08:20:52 GMT

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

PrashantSangle — Thu, 27 Mar 2014 08:33:49 GMT

Hi,

Please find attached file.

Regards,

Re: Copy to clipboard number format

qlikpahadi07 — Thu, 27 Mar 2014 08:34:43 GMT

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 .

Re: Copy to clipboard number format

qlikpahadi07 — Thu, 27 Mar 2014 08:37:02 GMT

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