1 Reply Latest reply: Feb 8, 2018 3:23 PM by Scott Holcomb RSS

    Date Field in Pivot Table Exporting to Excel With Incorrect Formatting

    Scott Holcomb



      We're upgrading from QlikView 11.20 to QlikView 12 November 2017 SR2 and have run into a weird issue while testing. We have a Straight Table that has three date fields in the table. When we export this table to Excel, everything looks good. However, if we do a Fast Change to a Pivot Table and do the same export, we get incorrect formatting for only one of the data fields. I've checked the formatting in the Document Properties and it matches the other date fields that export correctly. I tried to change it from M/D/YYYY to MM/DD/YYYY and we're still getting the same thing. Has anyone seen this issue? Any idea what's going on?