Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Read about the latest Qlik Community enhancements on the Community News blog!
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Send to Excel - Calculated Dimension sending as Text instead of Number

Hi, I have a simple calculated dimension =year(Date) that is converted to text when sending to Excel.

I have checked multiple other posts on this and I have tried various formulas Num(), Round(,), year()*1, etc...

I have set ExcelExportMixedAsText to 0 and reloaded

All to no resolve, any ideas?


For info, I'm using QV 11.2 and Excel 2010

2 Replies

Hi, create the field Year from Date in script, using this field should be exported as a number

LOAD ...


  Year(Date) as Year


Support (Former)
Support (Former)

You did not state which SR you are running in the 11.20 track, if you are not on SR13 or later, I would recommend trying the latest SR, which is 19, the full build number is 11.20.13804.  

If that does not help, if you can attach a sample app we can use to test things, we can confirm if we are able to replicate the issue or not.


To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.