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