Multiple Number Formats in Pivot Table

[gsan]

Hi,

I have a pivot table with multiple number formats (Number and Percentage) in expressions.

=if(wildmatch(uom,'*rate'), num(Sum(result_value), '##.##%'), num(Sum(result_value)))

When i use the above expression, the data looks good in Qlik Sense, but when i export to excel, they are getting converted to text. I changed the format from 'Auto' to 'Measure Expression', but still it exports as text. Any suggestions on how to fix this?

Thanks

Sam

[Ivan_Bozov]

Hi, see here: https://support.qlik.com/articles/000028063