topic Export to Excel in QlikView

Export to Excel

Thu, 12 Nov 2009 14:21:29 GMT

Hi,

When I export a chart to excel my date dimension is represented as the numeric value of the date e.g

39997

The user then needs to format the cell and set it to type Date. Is there a way to bypass this?

Thanks,

Thu, 12 Nov 2009 15:53:51 GMT

You must display your dimension as a TEXT:

In this case your dimension can be a calculated dimension such as TEXT(MyDateFiled)

This should make it work.

Anonymous — Thu, 12 Nov 2009 15:56:36 GMT

I purpose in Settings -> Document Properties -> Number you need to define a Date format for this field

Rgds,
Artjoms

Thu, 12 Nov 2009 16:41:18 GMT

Thanks both for the helpful suggestions!