Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

jorditorras
Contributor

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
Contributor III

Re: Export table with default format to Excel-numeric format

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
Contributor

Re: Export table with default format to Excel-numeric format

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
Contributor III

Re: Export table with default format to Excel-numeric format

Hi Jordi,

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

Community Browser