topic Re: Num# conversion not working (format code) in QlikView

Num# conversion not working (format code)

Qlik_SWO — Sat, 16 Nov 2024 03:06:20 GMT

Hi,

I need to convert the following Strings to Numbers:

I also want to remove the decimal place after the "," (It is always 000)

For the thousands separator, i want to show a comma instead of the "."

Example: Current String: 80.000,000 --> Expected Number: 80,000

Example 2: Current String: 200,000 --> Expected Number: 200

As I tried to understand, the right way to do this is something like that in the loading script :

Num#(CURRENTMAX,'#.#', ',', '.') as NEUMAX

I understood that the '#' operator denotes a possible digit to the left of the decimal point.
What is the right format code to get things working?

Thanks in advance! 😊

Re: Num# conversion not working (format code)

atoz1158 — Wed, 03 Jul 2019 14:44:46 GMT

If you are sure that your input is going to be in the format shown you could try the following

Replace(Replace(CURRENTMAX,',000',''),'.',',') ) as NEUMAX

Regards

Adrian

Re: Num# conversion not working (format code)

Rodrigo_Reis — Mon, 08 Jul 2019 21:09:52 GMT

You can adjust with the num function, but note that this is a mask:
=num(num#(CURRENTMAX, '#.## 0,000', ',', '.'), '#,##0')

You can also round off the number to make the decimal places disappear:
=floor(num#(CURRENTMAX, '#.##0,000', ',', '.'))
After this you apply num function