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: 
dhanavindhan
Creator
Creator

Number showing in Text in export to excel

Dear Community,

I have a calculated dimension, for calculating time interval between dates to find Age.

My cal.condition is,

=Num(Date(Opsdelay.odarrdate,'DD-MM-YYYY') - num(TODAY(),'DD-MM-YYYY'),'###0; ###0')

result is coming correct i have no issue in it. When my user export it to excel he face that this column is showing in text field as i mentioned "Num" before the my condition already. How do i fix it. I tried some of the community threads nothing worked. Qlik icon, Document properties Number tab etc....

Help me to fix this.

Reg,

Dhana R

0 Replies