Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a table when i try to copy to clipboard and paste it into excel, all the number format gone
What i got:
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?
anyone know how to solve this?
Sorry to reply PFA
Instead in Expression you can Format in "Number" Tab which will solve the issue in Export.
Hope this help Cheers !!!
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.
Please find attached file.
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 .
adding to previous I suggest you must edit your Query to avoid confusion or close/delete this thread and create a new one.