Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi, create the field Year from Date in script, using this field should be exported as a number
LOAD ...
Date,
Year(Date) as Year
...
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