My data contains numeric and %

[04382072]

My data contains numeric and % values but when I load them in the % data is converted to numeric - ie 50% shows as .5.  How can I get this to report correctly within Qlik Sense ?

[treysmithdev]

What is correct in this scenario? In most tools a field will be conformed to a single data type/format.  If you want 50% to be 50, then you will need to account for that in the load script. If you want it to display as 50%, then you will have to convert the field to text. 

To strip the % and make it 50, you can do something like:

Num#(PurgeChar(Text([Field]),'%')) as [Field]

[anseglko]

When you put the % value to a chart, you can edit the properties, change "Number formatting" to "Custom" and in the "Format pattern" replace "#,##0.00" with "#,##0%" (or "#,##0,0%" for 1 decimal). Qlik should convert values like 0.5 to 50% by itself.