topic Re: Converting text into a number in QlikView

Converting text into a number

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Akina0929 — Fri, 09 Feb 2018 07:23:13 GMT

Hi '

use following expression

=num(0000000089548436)/100

Regards

Anji

tresB — Fri, 09 Feb 2018 07:43:34 GMT

Change the load script settings like:

SET ThousandSep=' ';

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

ramasaisaksoft — Fri, 09 Feb 2018 11:22:40 GMT

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