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

Export table with default format to Excel-numeric format

Dear Gurús,

I have a table with some KPI's and I have to set the format as "default format" (the reason is that I'm applying one variable only Works by setting Degalta Format). When exporting to Excel, it appears as Text Format. Is it any way to Export it as numeric format?

Thanks,

Regards

3 Replies
kuczynska
Creator III
Creator III

Hi,

You can always try to use NUM() in the expression itself. By doing this the Expression Default format will default to the one set in the expression, which is a numeric format.

jorditorras
Creator
Creator
Author

Hi Kuczynska,

Thanks for your message, but I defined all the expressions with NUM() and, (supposedly) as I set the numer format as default, then it still treat the KPI's as text when exporting it to Excel...

Thanks again.

Regards,

Jordi

kuczynska
Creator III
Creator III

Hi Jordi,

In that case you would have to share your sample qvw so we could have a look at it. Is that possible?