Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
I am facing an issue since yesterday. One of my reports have date columns and are in format 'DD-MM-YYYY' but when this reported is exported to excel the date is converted to Text string, which makes it unusable for further calculations.
I have tried every possible way which i could think of and I am sure that this is a bug. I want a confirmation from you guys.
Thanks,
Alkesh
Hi,
Go to Help tab->Click on About Qlikview (You get new window)->right click on Qlikview Icon (left bottom)->You get setting window->select ExcelExportMixedAsText->set its value to 0 from 1
Regards
Tried, but not working.
This was the very first thing I tried, not working
which QV Version are you using?
Hello Vivek
Its, Version 11.0 SR2.
this is a bug in this version.
upgrade to QV 11.2SR9.
Regards,