topic Export to Excel in QlikView

Export to Excel

hopkinsc — Thu, 24 May 2012 10:57:02 GMT

Hi, i have a problem when exporting into Excel.

I have used the following expression..

When i export this to excel, it exports as text even though i have stated the number format above.

The expression is set at default on the number tab as the above expression included currency and percentages.

Can anyone help please?

Sorry about the rubbish image above. I am at a clienst site and cant seem to copy and paste text from their Qlikview server!

This has also been posted in 'New to Qlikview'

Export to Excel

hopkinsc — Thu, 24 May 2012 11:40:49 GMT

does anyone have any ideas please?

Export to Excel

flipside — Thu, 24 May 2012 14:01:58 GMT

Hi,

I get the same when I try this. The formatting is lost once you wrap an IF statement around it.

If you are trying to export a straight table with just currency, or just numeric or just percentages (i.e. not mixed formatting), then you could try having separate expressions for each value of Line_Item so each column's number formatting can be set separately. The Expression labels should all be the same (eg TOTAL).

Then set each of the columns to Conditional show (Presentation tab) only when that value is individually selected ... eg ONLY(LineItem)='RET'.

As you select the LineItems the TOTAL is calculated with the required formatting and exports to Excel as needed.

flipside