Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Partner
Partner

Why am I losing formatting when exporting to excel?

This question is posted in the archives but I can't see the attachments associated with the archives so I'm asking again.

I've got a pivot table that has custom number/date formatting applied to an expression. When I export that chart to excel I lose my formatting.

Any ideas on how to deal with this would be appreciated.

Thanks

QlikView

F1 F2 F3 Expression
date08/17/1967M/D/YYYY8/17/1967
time12:45:00h:mm:ss tt12:45:00 pm
dollar12345.67$#,##0;($#,##0)$12,346
percent.7952##0.00%;-##0.00%79.52%
dollar1-12345.67$#,##0;($#,##0)($12,346)
percent1-.7952##0.00%;-##0.00%-79.52%


Excel

F1F2F3Expression
date08/17/1967M/D/YYYY24701
time12:45:00h:mm:ss tt0.53125
dollar12345.67$#,##0;($#,##0)12345.67
percent.7952##0.00%;-##0.00%0.7952
dollar1-12345.67$#,##0;($#,##0)-12345.67
percent1-.7952##0.00%;-##0.00%-0.7952
No selections


Tags (3)
2 Replies
Partner
Partner

Why am I losing formatting when exporting to excel?

Try with this expression:

If(F1 = 'date' or F1 = 'time', text(date(F2,F3)),text(num(F2,F3)))

Basically convert it to text first.

Partner
Partner

Why am I losing formatting when exporting to excel?

Rakesh,

Thanks for the response. This works great with keeping the formatting in excel. But, I have now I've lost my ability to use the actual values of the numbers in excel. They've been transalted into text. Is there any way to convert the numbers and keep the formatting? Similar as to when you have Money selected on the number tab and do an export. It keeps the formatting as well as the values of the numbers.

Oscar