Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
Showing results for 
Search instead for 
Did you mean: 

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.


Dhana R

0 Replies