Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
debashisamant
Contributor
Contributor

Unable to export Date fields

Hi All,

While I am exporting my date fields (or number fields) in qlikview ,they are getting converted to text in the excel file.Is there any way we can fix this.

For number fields ,if we use round() function in expression , they appear as numbers in the exported excel.Is there any cheat available for date fields as well, for exporting them as dates(and not as text).We are using QlikView 12.

 

Thanks in advance

Labels (2)
3 Replies
tincholiver
Creator III
Creator III

Did you try formatting it from the number flap?
there you can tell him that numerical format has that expression
debashisamant
Contributor
Contributor
Author

Hii  Tincholiver,

Thanks for the suggestion,but we are having our date fields in the dimensions in the Qlik charts.And our management don't wish to use excel to format the dates .They wish the output from Qlik should be, by default  in date format.

Please tell me if  I got your thoughts correctly.

tincholiver
Creator III
Creator III

Can you upload a table with some record with date format datebase and how in excel is downloadaded?