Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
BI_Dev
Creator II
Creator II

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 ?

 

 

 

 

Labels (4)
2 Replies
Brett_Bleess
Former Employee
Former Employee

@BI_Dev 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