Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
gsan
Contributor II
Contributor II

Multiple Number Formats in Pivot Table

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

Labels (2)
1 Reply
Ivan_Bozov
Luminary
Luminary