Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
saivina2920
Creator
Creator

Date format not coming proper while exporting to excel from straight table chart

I am using below expression in my qlikview chart straight table.

Dimensions

=If(vUserInput, if(IsNull(EMP_RELIEVE_DATE) , EMP_RESIGN_DATE), if(not IsNull(EMP_RELIEVE_DATE) , EMP_RELIEVE_DATE))

Expressions

=If(vUserInput, if(IsNull([EMP_RELIEVE_DATE]) , Date(EMP_RESIGN_DATE+vUserInput)), if(not IsNull([EMP_RELIEVE_DATE]) , EMP_RELIEVE_DATE))

While exporting into excel, the date format coming as "42301","45219",etc,

 

saivina2920_0-1610563152232.png

Is there anything need to change the format in dimensions or expressions...?

 

1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

Did you activate the date format for your expression?

Frank_Hartmann_0-1610564392751.png

 

View solution in original post

2 Replies
Frank_Hartmann
Master II
Master II

Did you activate the date format for your expression?

Frank_Hartmann_0-1610564392751.png

 

View solution in original post

saivina2920
Creator
Creator
Author

Thanks..It's working