Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear gurus ...i have been searching and reading all the Solved solutions but all these were not helping
Please refer attached Excel Sheet, all the date columns are correct Except the 'Activities Dates Column'. For your information, the same chart has been done in Qlikview and the column has got no problem after Export to Excel . Wonder why it only happens in Qliksense, and to that specific column only.
@limfungkeatSocrates GM wrote:
Dear gurus ...i have been searching and reading all the Solved solutions but all these were not helping
Please refer attached Excel Sheet, all the date columns are correct Except the 'Activities Dates Column'. For your information, the same chart has been done in Qlikview and the column has got no problem after Export to Excel . Wonder why it only happens in Qliksense, and to that specific column only.
Hello, @limfungkeat
I can see your post, That you’re encountering an issue with date formats when exporting data from QlikSense to Excel. Specifically, the ‘Activities Dates Column’ is not displaying correctly in Excel. Let’s address this:
Date Format Issue:
Possible Solution:
Test and Verify:
Remember to adjust the expression according to your specific date field name and desired format. If you encounter any further issues, Please tell me I am happy to help you.
Best Regard,
ryan1969
Thanks Ryan ..but i have mentioned in my post that , i did referred and already done the solution you proposed. But still the data is not exported with the format as required .
I think the problem still lies with formatting. Please provide a raw sample of the field named 'Activities Dates'.