Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
BIDev
Creator
Creator

DATE WHEN EXPORTED CHANGES TO TEXT

I have below field in dimension, but when exported it changes to text format.

if(GetFieldSelections([Date Format])='US',date([Date],'MM/DD/YYYY'),
 if(GetFieldSelections([Date Format])='International',date([Date],'DD/MM/YYYY')))

 

when this is exported to excel it changes to text,,,any thoughts please ?

 

 

 

 

2 Replies
Brett_Bleess
Support (Former)
Support (Former)

@BIDev have a look at the following article, might be what you have run into, but not enough info provided for me to be sure:

https://community.qlik.com/t5/Support-Knowledge-Base/Qlik-Sense-Business-and-Export-to-Excel-issues/...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
prachimishra29
Contributor
Contributor

Use the Date function in the frontend while using in the Table or creating Master Item. This solved my format change issue while exporting to excel.

prachimishra29_0-1603914221876.png