Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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