Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
beck_bakytbek
Master
Master

Num# of numbers

Hi Folks,

my filed does look like:

Class

120,00

 

i am trying to format (from 120,00 to 120) it by using of function num#() but i dont achieve any expected results.

Does anybody have any idea?

Thanks a lot

1 Solution

Accepted Solutions
marcus_sommer

For me it worked with:

num(num#('120,00', '###,##', ',', '.'), '#.##0')

floor(num#('120,00', '###,##', ',', '.'))

- Marcus

View solution in original post

6 Replies
Akshesh_Patel
Support
Support

hello,

something like this,

Num(number[, format[, dec_sep [, thou_sep]]])

 

Regards,

Akshesh

beck_bakytbek
Master
Master
Author

Hi Akshesh,

 thanks a lot for your responce, i implemented that, but it does not work 

marcus_sommer

Num#() is for converting a string into a number - it will return (if the recognition-pattern is set properly) the number with the default number-format (set per variable in the main-tab of the script). If you want to change the format you need to adjust this variable or to wrap the num#() with a num(). Important by adjusting the delimiter is that all parameter of num() are set.

Another way in your case might be just to use floor().

- Marcus

beck_bakytbek
Master
Master
Author

Hi Marcus,

thanks a lot for your responce, i tried to implement it by using of Floor-function, as Floor(120,00), but it does not work

marcus_sommer

For me it worked with:

num(num#('120,00', '###,##', ',', '.'), '#.##0')

floor(num#('120,00', '###,##', ',', '.'))

- Marcus

beck_bakytbek
Master
Master
Author

Hi Marcus,

thanks a lot for your time and help, it does work great