Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Converting text into a number

Please assist, i have a text that i have to convert into a number.

The text looks loke this 0000000089548436, i need to remove all leading zeros and have a decimal point before two last digits.

a thousand separator should be a space.

The result should look like 895 484.36


Thank you

3 Replies
Akina0929
Creator
Creator

Hi '

  use following expression

   =num(0000000089548436)/100


Regards

Anji

tresesco
MVP
MVP

Change the load script settings like:

SET ThousandSep=' ';

Capture.JPG

You can use this formatting/transformation during the load as well.

ramasaisaksoft

=Num(0000000089548436,'#,###.#0')

num.png