topic Re: Hey guys, Export Issues to Excel-Need help about data format QlikView application to excel in QlikView

Hey guys, Export Issues to Excel-Need help about data format QlikView application to excel

gopalmadi5885 — Mon, 26 Mar 2018 16:18:12 GMT

In the QlikView application, it is showing right format as show in screen shot a). When I export it tot Excel, it is not pulling in the right format as show in Screen shot b). Can you please give me any hint or help. Using Internet Explorer 11

Screen Shot a)

Screen Shot b)

Re: Hey guys, Export Issues to Excel-Need help about data format QlikView application to excel

shiveshsingh — Mon, 26 Mar 2018 17:18:44 GMT

In excel, your date is not getting converted during pulling.

This should not happen, can you share your sample app>?

Re: Hey guys, Export Issues to Excel-Need help about data format QlikView application to excel

passionate — Mon, 26 Mar 2018 17:24:43 GMT

Are all other date fields exported as Expected?

Re: Hey guys, Export Issues to Excel-Need help about data format QlikView application to excel

gopalmadi5885 — Mon, 26 Mar 2018 17:34:34 GMT

All other fields ok , Expect Date fields

Also I need to substitute blank for "-" hypens. Is there any simpler way to do . The Yellow which I highlighted portion of it substituted by "-". Application data looks Ok, when I export it, it is causing the issue.

On Mozilla browser, it looks ok

Re: Hey guys, Export Issues to Excel-Need help about data format QlikView application to excel

gopalmadi5885 — Mon, 26 Mar 2018 17:35:50 GMT

Sharing screen shot Shiv