Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
knightwriter
Creator III
Creator III

Extract to Excel 2013: Pivot Timeline function

Hi All,

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.

I have saved the excel first prior Qlikview extract and have changed the column settings to short date and still no dice.

Any suggestions?

Thanks

2 Replies
rrsrini2907
Creator
Creator

Hi,

Could you post the excel with sample data?

Regards,

Srini.

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Use the Date#() function that let the QlikView interpret the field as a date.