topic Re: Send to Excel - Calculated Dimension sending as Text instead of Number in QlikView

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

stubarnes — Fri, 12 Jul 2019 12:43:48 GMT

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

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

rubenmarin — Mon, 15 Jul 2019 10:11:43 GMT

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

LOAD ...

Date,

Year(Date) as Year

...

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

Brett_Bleess — Wed, 07 Aug 2019 13:10:00 GMT

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.

Regards,
Brett