topic Re: Export to Excel date field in QlikView

Export to Excel date field

Tue, 07 Oct 2014 11:09:36 GMT

Hi, I have a date type field that I load like:

If([Close date]='01/01/1900','', Date([Close date]))

The problem come when I export a table with this field to excel, the column in excel have text format instead date format. Can I load the date with a null value instead ''?

Thanks

Re: Export to Excel date field

Tue, 07 Oct 2014 11:18:50 GMT

Make sure that in the chart properties, Close date, on the number tab, is marked as a date value:

Re: Export to Excel date field

Tue, 07 Oct 2014 11:27:10 GMT

Yes, but this field is a dimension, not an expression...

Re: Export to Excel date field

Tue, 07 Oct 2014 12:21:47 GMT

Hi,

Please Try with below Code

If([Close date]='01/01/1900',Null(), Date([Close date]))

Regards,

Joshmi

Re: Export to Excel date field

Clever_Anjos — Tue, 07 Oct 2014 12:29:42 GMT

Please remove your calculated dimension and use another strategy to filter your graph. It´s the best way

You can use a combination of Set Analysis/Supress Zeros to filter your object

Re: Export to Excel date field

Tue, 07 Oct 2014 12:31:49 GMT

The thing is, that if you use, both text '' and date values, you will get a text field instead of a date field.

You could generate this dimension during the load script:

If([Close date]<>'01/01/1900', Date([Close date])) as [Close date]