topic Re: Extract to Excel 2013: Pivot Timeline function in QlikView https://community.qlik.com/t5/QlikView/Extract-to-Excel-2013-Pivot-Timeline-function/m-p/1089241#M918000 <HTML><HEAD></HEAD><BODY><P>Use the Date#() function that let the QlikView interpret the field as a date.</P></BODY></HTML> Fri, 06 May 2016 10:12:47 GMT MindaugasBacius 2016-05-06T10:12:47Z Extract to Excel 2013: Pivot Timeline function https://community.qlik.com/t5/QlikView/Extract-to-Excel-2013-Pivot-Timeline-function/m-p/1089239#M917998 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am using excel 2013 and when I take an extract from a .qvw file with dates, the pivot will not create the timeline function as it does not recognize the field as a date.</P><P></P><P>I have saved the excel first prior Qlikview extract and have changed the column settings to short date and still no dice.</P><P></P><P>Any suggestions? </P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Extract-to-Excel-2013-Pivot-Timeline-function/m-p/1089239#M917998 knightwriter 2020-11-25T16:16:04Z Re: Extract to Excel 2013: Pivot Timeline function https://community.qlik.com/t5/QlikView/Extract-to-Excel-2013-Pivot-Timeline-function/m-p/1089240#M917999 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Could you post the excel with sample data?</P><P></P><P>Regards,</P><P>Srini.</P></BODY></HTML> Fri, 06 May 2016 10:07:14 GMT https://community.qlik.com/t5/QlikView/Extract-to-Excel-2013-Pivot-Timeline-function/m-p/1089240#M917999 rrsrini2907 2016-05-06T10:07:14Z Re: Extract to Excel 2013: Pivot Timeline function https://community.qlik.com/t5/QlikView/Extract-to-Excel-2013-Pivot-Timeline-function/m-p/1089241#M918000 <HTML><HEAD></HEAD><BODY><P>Use the Date#() function that let the QlikView interpret the field as a date.</P></BODY></HTML> Fri, 06 May 2016 10:12:47 GMT https://community.qlik.com/t5/QlikView/Extract-to-Excel-2013-Pivot-Timeline-function/m-p/1089241#M918000 MindaugasBacius 2016-05-06T10:12:47Z