topic Export table with default format to Excel-numeric format in QlikView

Export table with default format to Excel-numeric format

jorditorras — Wed, 02 Mar 2016 14:52:48 GMT

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

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

kuczynska — Mon, 07 Mar 2016 11:58:53 GMT

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.

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

jorditorras — Mon, 07 Mar 2016 12:10:10 GMT

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

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

kuczynska — Mon, 07 Mar 2016 13:20:18 GMT

Hi Jordi,

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