Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to change the string '0000039041005545' to '39041055545' in Qlik Sense
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.
Try loading the field using the Evaluate() function in the script, e.g.
Num(Evaluate(Field)) as Field,
Thank you for your recovery~ but this function(Evaluate) is not applicable
Num(Num#(yourfield,'#,##0'),'#0') as field name
Or
Field+0 as newfield
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.
Thank you very much for your answer. It can fully achieve the display I need