What is the difference between Num and Num# function?

[jblomqvist]

Hi there,

Can anyone explain to me please what is the difference between Num and Num# function?

I tried looking in the Help and it seems to suggest that Num is used for formatting purposes while Num# is for string value conversions?

[Anonymous]

Perfect Explanation

[Qliksense_User]

Num#('22%', '0%')   does not give 22%, instead it gives 0.22

Num#('2,200', '#,##0') does not  give 2,200. instead it gives 2.2K

Num('2,200' , '0,000') gives 2,200