Qlik Sense's handling of leading zeros in strings

[wl1]

How to change the string '0000039041005545' to '39041055545' in Qlik Sense

[hic]

Try loading the field using the Evaluate() function in the script, e.g.

Num(Evaluate(Field)) as Field,

[wl1]

Thank you for your recovery~  but this function(Evaluate) is not applicable

[anat]

Num(Num#(yourfield,'#,##0'),'#0') as field name 

Or

Field+0 as newfield

[hic · Accepted solution]

Oh, yes, you can use Evaluate(). 

However, not in a UI expression. You need to use it in the script when you load the field. Try it there, and you'll see.

[wl1]

Thank you very much for your answer. It can fully achieve the display I need