Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi, see here: https://support.qlik.com/articles/000028063