topic Problems showing in dates when exporting Pivot table to Excel in QlikView https://community.qlik.com/t5/QlikView/Problems-showing-in-dates-when-exporting-Pivot-table-to-Excel/m-p/1317682#M408835 <HTML><HEAD></HEAD><BODY><P style="text-align: left; color: #575757; text-indent: 0px; font-family: arial, helvetica, sans-serif; font-size: 13.33px; font-style: normal; font-weight: normal;">Dear All,</P><P style="text-align: left; color: #575757; text-indent: 0px; font-family: arial, helvetica, sans-serif; font-size: 13.33px; font-style: normal; font-weight: normal;"></P><P style="text-align: left; color: #575757; text-indent: 0px; font-family: arial, helvetica, sans-serif; font-size: 13.33px; font-style: normal; font-weight: normal;">We are facing a weird issue when exporting Pivot table to excel.</P><P style="text-align: left; color: #575757; text-indent: 0px; font-family: arial, helvetica, sans-serif; font-size: 13.33px; font-style: normal; font-weight: normal;">On the Dashboard the data is showing correct but once exported to excel a new field is added with wrong dates filled.</P><P style="text-align: left; color: #575757; text-indent: 0px; font-family: arial, helvetica, sans-serif; font-size: 13.33px; font-style: normal; font-weight: normal;"></P><P style="text-align: left; color: #575757; text-indent: 0px; font-family: arial, helvetica, sans-serif; font-size: 13.33px; font-style: normal; font-weight: normal;">Dashboard Show correct data as shown in the attached screen.</P><P style="text-align: left; color: #575757; text-indent: 0px; font-family: arial, helvetica, sans-serif; font-size: 13.33px; font-style: normal; font-weight: normal;"></P><P style="text-align: left; color: #575757; text-indent: 0px; font-family: arial, helvetica, sans-serif; font-size: 13.33px; font-style: normal; font-weight: normal;"><SPAN style="font-size: 13.33px;">Excel Show Wrong data as shown in the attached screen highlighted in yellow :</SPAN></P><P style="text-align: left; color: #575757; text-indent: 0px; font-family: arial, helvetica, sans-serif; font-size: 13.33px; font-style: normal; font-weight: normal;"></P><P style="text-align: left; color: #575757; text-indent: 0px; font-family: arial, helvetica, sans-serif; font-size: 13.33px; font-style: normal; font-weight: normal;"><SPAN style="font-size: 13.33px;">Please let me know what could be the solution to avoid such Case.</SPAN></P><P style="text-align: left; color: #575757; text-indent: 0px; font-family: arial, helvetica, sans-serif; font-size: 13.33px; font-style: normal; font-weight: normal;">Thanks a Lot.</P></BODY></HTML> Mon, 17 Jul 2017 10:31:40 GMT elie_issa 2017-07-17T10:31:40Z Problems showing in dates when exporting Pivot table to Excel https://community.qlik.com/t5/QlikView/Problems-showing-in-dates-when-exporting-Pivot-table-to-Excel/m-p/1317682#M408835 <HTML><HEAD></HEAD><BODY><P style="text-align: left; color: #575757; text-indent: 0px; font-family: arial, helvetica, sans-serif; font-size: 13.33px; font-style: normal; font-weight: normal;">Dear All,</P><P style="text-align: left; color: #575757; text-indent: 0px; font-family: arial, helvetica, sans-serif; font-size: 13.33px; font-style: normal; font-weight: normal;"></P><P style="text-align: left; color: #575757; text-indent: 0px; font-family: arial, helvetica, sans-serif; font-size: 13.33px; font-style: normal; font-weight: normal;">We are facing a weird issue when exporting Pivot table to excel.</P><P style="text-align: left; color: #575757; text-indent: 0px; font-family: arial, helvetica, sans-serif; font-size: 13.33px; font-style: normal; font-weight: normal;">On the Dashboard the data is showing correct but once exported to excel a new field is added with wrong dates filled.</P><P style="text-align: left; color: #575757; text-indent: 0px; font-family: arial, helvetica, sans-serif; font-size: 13.33px; font-style: normal; font-weight: normal;"></P><P style="text-align: left; color: #575757; text-indent: 0px; font-family: arial, helvetica, sans-serif; font-size: 13.33px; font-style: normal; font-weight: normal;">Dashboard Show correct data as shown in the attached screen.</P><P style="text-align: left; color: #575757; text-indent: 0px; font-family: arial, helvetica, sans-serif; font-size: 13.33px; font-style: normal; font-weight: normal;"></P><P style="text-align: left; color: #575757; text-indent: 0px; font-family: arial, helvetica, sans-serif; font-size: 13.33px; font-style: normal; font-weight: normal;"><SPAN style="font-size: 13.33px;">Excel Show Wrong data as shown in the attached screen highlighted in yellow :</SPAN></P><P style="text-align: left; color: #575757; text-indent: 0px; font-family: arial, helvetica, sans-serif; font-size: 13.33px; font-style: normal; font-weight: normal;"></P><P style="text-align: left; color: #575757; text-indent: 0px; font-family: arial, helvetica, sans-serif; font-size: 13.33px; font-style: normal; font-weight: normal;"><SPAN style="font-size: 13.33px;">Please let me know what could be the solution to avoid such Case.</SPAN></P><P style="text-align: left; color: #575757; text-indent: 0px; font-family: arial, helvetica, sans-serif; font-size: 13.33px; font-style: normal; font-weight: normal;">Thanks a Lot.</P></BODY></HTML> Mon, 17 Jul 2017 10:31:40 GMT https://community.qlik.com/t5/QlikView/Problems-showing-in-dates-when-exporting-Pivot-table-to-Excel/m-p/1317682#M408835 elie_issa 2017-07-17T10:31:40Z